Hi all,
Looking for some help with how to create a button on an excel file to clear a range of data (but not the whole worksheet) for easier clearance of data, rather than having to do it manually.
I have attached the worksheet for reference and below is the ranges that i want to clear using the macro button:
298R x 20C (A3:T3 and down 300 rows) and 298R x 4C (W3:Z3 and down 300 rows.
This leaves formatting and column headers as well as some formula in the middle of the document without clearing.
Any help will be greatly appreciated!
Thanks
Bookmarks