Google Sheets: Referencing Data from 6 Sheets to One master

TheCuder

New Member
Joined
Jan 21, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.
 
Last edited by a moderator:

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,223,950
Messages
6,175,582
Members
452,653
Latest member
craigje92

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top