Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking a column of data to a row or data in another document | Excel Discussion (Misc queries) | |||
Linking Data | Excel Worksheet Functions | |||
Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
Linking data | Excel Discussion (Misc queries) | |||
Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions |