VBA creating an Archive

[Fredek]

Hi guys,

I am trying to create an archive tab for my data using VBA. The aim is each day when I run this code the rows with "Daily" in the Archive column copy over to the Archive tab. Archive "Monthly" would copy over only one a month e.g. on the last working day of the month.


Data Sheet:

A	B	C	D	E	F	G	Archive
							Daily
							Monthly

<tbody>
</tbody>

How do you guys think it's best to approach this? Filtering or looping?

Follow up question, if I run the code multiple times a day, how can I ensure only one set of daily observations remains in the Archive tab?

 

[Roderick_E]

First question, does your data have a UID, "unique identifier" or reference? Some number that indicates a unique record? You might look at http://rodericke.com/exceldb