View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie R. Bernie R. is offline
external usenet poster
 
Posts: 24
Default 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.