PDA

View Full Version : Copying certain rows of worksheet into new worksheet depending on date



Alison1311
01-12-2018, 03:48 AM
I'm trying to copy the whole data from a masterwork sheet on to sub worksheets 2017, 2018. On the 2017 sheet I dont want it to copy rows that have a disposal date of 2017 in a column.

mana
01-12-2018, 04:01 AM
you can use "advancedfilter"