Hi,
I have a spreadheet with several worksheets they are all more or less the same just for different areas.
In each sheet i have a filter which filters the same information for each area just for e.g. sheet 1 will filter area 1 sheet 2 will filter area 2 etc.
The issue i have is were this is dragged from is updated on a daily basis but can change daily, so the filters are always out of sync and i have to refresh them all, is there a way that when i open the spreadhseet that the filters refresh automatically.
The filters drag the info from a worksheet named "Out Of Stocks", this worksheet is updated from another spreadsheet elsewhere, so i want this worksheet to update first and then the filters auto filter again and bring the correct info.
Thanks
I have a spreadheet with several worksheets they are all more or less the same just for different areas.
In each sheet i have a filter which filters the same information for each area just for e.g. sheet 1 will filter area 1 sheet 2 will filter area 2 etc.
The issue i have is were this is dragged from is updated on a daily basis but can change daily, so the filters are always out of sync and i have to refresh them all, is there a way that when i open the spreadhseet that the filters refresh automatically.
The filters drag the info from a worksheet named "Out Of Stocks", this worksheet is updated from another spreadsheet elsewhere, so i want this worksheet to update first and then the filters auto filter again and bring the correct info.
Thanks