Remove and Replace all information

[nathandavies]

Hi All,

I have a code which is assigned to a button, when the button is pressed the below macro runs and selects and copies all information which has a figure in column H and pastes it into a new work sheet "ORDER REC"

I was wondering if there is a way of deleting all the information in "ORDER REC" when the button is pressed and re-pasting the updated information into the work sheet.

Please Login or Register  to view this content.

This is my current code any help would be greatly appreciated.

[StephenR]

If I understand correctly, put this somewhere at the start of your code:

Please Login or Register  to view this content.

[nathandavies]

Will this clear my headers though, it needs to start at row 2

[StephenR]

Please Login or Register  to view this content.