Forum Discussion

nancebloggs's avatar
nancebloggs
Copper Contributor
Jul 14, 2022
Solved

auto update of lists monthly

Hi all, I have a spreadsheet with several workbooks which I need to update monthly. They are reports on different supplier sales figures & items. Each supplier has their own worksheet where I usuall...
excel
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Jul 18, 2022

    Hi nancebloggs 

     

    there are several options I can think of, depending on the Excel version that you use.

    If you use Microsoft 365/Office 365, you could take the new FILTER function to get dynamically the relevant data from the master sheet into each supplier sheet.

     

    Another option which works also with Excel 2016 - 2021 is Power Query. Load the data from your master sheet into Power Query where you can apply filters by supplier. And then load the results into the supplier sheet.

     

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Jul 18, 2022

Hi nancebloggs 

 

there are several options I can think of, depending on the Excel version that you use.

If you use Microsoft 365/Office 365, you could take the new FILTER function to get dynamically the relevant data from the master sheet into each supplier sheet.

 

Another option which works also with Excel 2016 - 2021 is Power Query. Load the data from your master sheet into Power Query where you can apply filters by supplier. And then load the results into the supplier sheet.

 

nancebloggs's avatar
nancebloggs
Copper Contributor
Aug 18, 2022

Martin_Weiss thanks so much! Filter function worked!!

Resources