Hi,
Not super familiar with the platform, but trying my best. This instance is referring to google sheets, but excel and sheets seem to be pretty similar. I am trying to reference data from multiple sheets into a master summary sheet.
I started with just referencing the sheets and the cell with the =sheet1!A2 function and then carried it through the 300 columns, but was running it #Ref when the data was moved or deleted from the referenced page.
I then moved to using =INDIRECT("Sheet1!$A2"&ROW(B2)). Carried it through the rows from the 6 sheets. The information is populating onto the master correctly. I am trying to apply the data filter to filter the master by dates. Sometimes the sheet looks like it tries to filter and then updates back into the order it is listed on the referenced pages or its updates and everything goes to #Ref.
Am I using the incorrect function for this or do I need to build a filter into the script? The only issue is if I build the filter in I filter by 4 different columns of dates and not sure if this would affect the others.
Any help would be greatly appreciated.
Not super familiar with the platform, but trying my best. This instance is referring to google sheets, but excel and sheets seem to be pretty similar. I am trying to reference data from multiple sheets into a master summary sheet.
I started with just referencing the sheets and the cell with the =sheet1!A2 function and then carried it through the 300 columns, but was running it #Ref when the data was moved or deleted from the referenced page.
I then moved to using =INDIRECT("Sheet1!$A2"&ROW(B2)). Carried it through the rows from the 6 sheets. The information is populating onto the master correctly. I am trying to apply the data filter to filter the master by dates. Sometimes the sheet looks like it tries to filter and then updates back into the order it is listed on the referenced pages or its updates and everything goes to #Ref.
Am I using the incorrect function for this or do I need to build a filter into the script? The only issue is if I build the filter in I filter by 4 different columns of dates and not sure if this would affect the others.
Any help would be greatly appreciated.
Last edited by a moderator: