Linking multiple data into one worksheet.
Hi all
I am trying to create a summary worksheet which colates data from other
spreadsheets. The problem is that I cannot use the autofill for more that
two columns.
This is what I am trying to create:
Summary Sheet
A B C D E F
1DATE
2DATE
Date= Day1 3DATE
4DATE
5DATE
A B C D E F
1DATE
2DATE
Date= Day2 3DATE
4DATE
5DATE
Other worksheets with data to be linked: (I have 5 in total) look like this
A B C D E F
1DATE
I am trying to link
Worksheet 1, A1 to Summary Sheet A1 and;
Worksheet 2 A1 to Summary Sheet A2 etc..
The problem is that I can do it for 1 block as in Summary Sheet Day 1
however I am not sure how to reference the other cells.
If anyone can help I would much appreciate it.
If you need to spreadsheet in question, then let me know and I can email it
for clarification.
Thanks in advance
Patrick
|