Hello Everyone,
I have a fairly large worksheet containing data in about 50 columns or let's say in 50 categories. There are 5 additional columns containing formulas referring to some of the 50 columns mentioned previously. These 55 columns are used as source data for other worksheets that contain charts & formulas. The data on the source worksheet is autofiltered to have a convenient view on certain criteria.
I have to delete some parts (complete rows) of the source worksheet based on some criteria (hence the autofilter) regularly and paste new data instead of those.
I pick the rows I want to get rid of by using the filters. When chosen, I select and delete (entire) rows. Then I de-filter data, deactivate autofilter and paste new data after the last row, following the exact order of the sheet.
Here's the thing: after pasting the fresh data to the relevant 50 columns and copying the formulas in the additional 5 columns from above, autofilter won't filter the newly pasted data anymore. Those won't show up in the dropdowns of the filter, only previous contents are shown. It's important that the first newly pasted row is non-blank, contains data in all cells, the format of the cells are identical to the previous ones. Before pasting fresh data I even delete all additional rows and columns after the untouched source data. After having pasted the new stuff I refresh the whole chart. Still...
Any ideas how I could include the new data in the filter?
Thanks a lot!
Bookmarks