RosieG1991
New Member
- Joined
- Feb 23, 2017
- Messages
- 21
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?
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?