Linking data from multiple spreadsheets into one

  • Thread starter Thread starter Bernie R.
  • Start date Start date
B

Bernie R.

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.
 
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
 
Back
Top