| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data from multiple spreadsheets into one
Is there a way to link multiple rows of data from multiple spreadsheets
without typing this for every entry? =IF(Sheet1!A1="","",Sheet1!A1) Majority of the data are dates when a training event was conducted. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking data from multiple spreadsheets into one
Put some data in A1 of Sheet2 and Sheet3
Now experiment with =INDIRECT("Sheet"&COLUMN()-3&"!A1") in a cell in column D of Sheet1 You should be able to adapt this to your needs best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Bernie R." <Bernie wrote in message ... Is there a way to link multiple rows of data from multiple spreadsheets without typing this for every entry? =IF(Sheet1!A1="","",Sheet1!A1) Majority of the data are dates when a training event was conducted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Spreadsheets for Data Validation | Excel Discussion (Misc queries) | |||
| synchronizing data on multiple spreadsheets | Excel Worksheet Functions | |||
| Linking data and formating between two spreadsheets | Excel Discussion (Misc queries) | |||
| Linking Excell Spreadsheets and Resorting Data | Excel Worksheet Functions | |||
| Linking Excell Spreadsheets and Resorting Data | Excel Worksheet Functions | |||
Linear Mode
