Hi
Hope soemone can help as I'm definitely stumped on why this is happening here
I recorded a Macro that takes unique dates from a large sample of dates (i.e in the sample the 20th Feb appears 300 times but I only want to paste 1 example of this in another part of the excel book)
The macro firstly uses advanced filter function on the data looking for unique records on the date column and then copies the unique list of dates to another sheet
However when it pastes it in the other sheet it consistently pastes it in a different location each time. This wouldnt be so bad but I aim to have formulae set up to reference the unique dates so it needs to go into the same place each time and this is exceptionally puzzling
Very very grateful for any thoughts
Bookmarks