Creating a Dynamically Linked Worksheet

B

BRob

I want to create a simple spreadsheet where Row 1 is text headings and rows
2 to xx is data copied from columns of another spreadsheet.

The final row xx, can be variable - although it will be the same for all
columns.

I vaguely remember seeing a post that used an INDEX command as a solution to
fill rows 2 to xx - but can't find it.

Can anyone help with a solution

TIA

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating summary table of input from other worksheets 1
Dynamic Range Using INDEX instead of Offset 4
vertical and horizontal lookup? 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Copy data from 1 sheet to multiple worksheets 2
ISERROR and INDEX Funcion question 8
Populate and create duplicates on second worksheet 0
Create Workbooks and then create Worksheets within them 2

Top