Lookup solution

[RosieG1991]

I have a workbook with multiple worksheets.
Two of the worksheets pull data from one source (worksheet that gets updated regularly) using vlookups etc.
The worksheet in which the data is pulled from changes size all the time, sometimes I may have 100's of new rows other times only 5 new rows and sometimes less rows.
In order for the 2 other worksheets to always grab all the new data I have applied my vlookups in these worksheets to most of the rows available in a worksheet so that I don't every miss anything due to not having the formula in the row.
I have also added to the formula to ignore the blanks so that I don't get 0's or #NA on rows where there is no data to pull

However what I have found is that unless I filter one of the columns in these 2 workbooks the new data doesn't appear.

Is there something I can do to rectify this? Can I add a button with some code behind it to be able to refresh the data (filter) in the 2 sheets?

 

[jasonb75]

If your formulas are not refreshing then it would suggest that you have set calculation to manual. The link below tells you how excel decides if calculation is manual or automatic, there is a section at the bottom that tells you how to calculate (refresh) your formulas when needed.

How Excel determines the current mode of calculation - Microsoft 365 Apps

Discusses how Excel determines the calculation mode. You can change the caculation mode in the Tools menu. You can press SHIFT+F9 to recaculate the active sheet and press F9 to recaculate all open documents.

docs.microsoft.com

If you need to refresh filters then try Ctrl Alt L (the shortcut to the re-apply button on the data tab of the excel ribbon).