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.

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.