how to stop overwriting data with vba

[ConfusedaboutVBA]

Hi guys

I'm having trouble with the finishing touches of my macro. I have a code that identifies if there is is a text in a certain cell & if there is then the macro copies & pastes the whole column of the cell that has the data into another sheet.

But I plan on adding new columns of data in my original sheet. So when I click the button for the below macro, I dont want it to delete my previous entries. Basically I want to keep a record of all archived data.

Does that make sense?

Please Login or Register  to view this content.

[smuzoen]

So when I click the button for the below macro, I dont want it to delete my previous entries

Are you talking about the Archive sheet? Instead of copying the data to a hardcoded column (i) find the last column dynamically.

Please Login or Register  to view this content.

[ConfusedaboutVBA]

Thanks for the reply but its not quite what I need.

So for example There is a whole heap of data in sheet WB2. When a person enters data in a particular cell (Cell39) then the macro will copy the whole column of the cell that contained the data and paste it into sheet WB3 (archive) & the record is deleted in WB2. However people will continue adding new data to WB2. So when the macro is run I dont want it overwriting the previous entries into WB3(archive)

I hope that makes sense =/