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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]Archive[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Daily[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Monthly[/TD]
[/TR]
</tbody>[/TABLE]

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