Hi All,

I'm having trouble with a workbook which i have created with help from the forum, my issue is that when i run a macro "order" it will run through all the worksheets and copy cells with a 1 or More in Column H ("QUANT") to a worksheet ("ORDER REC"). This works fine for the first run but i have to constantly update the document. When i update other worksheets and re-run the macro ("order") the macro deletes all content on the sheet ("ORDER REC") including the header and re copies the information with multiple headers, I have offset the range but it keeps on doing it after the first time. There are also buttons with assigned macros for Sorting and Hiding Cost's which get deleted every time!

Is it possible to reference the other sheets with a quantity in Column H ("QUANT") so once I have run the Order macro I can just go into the different sheets and update accordingly.

I have attached my workbook for your information.
LV SWITCHGEAR NEW QUOTE SHEET REV 001 - Development Copy ND.xlsmLV SWITCHGEAR NEW QUOTE SHEET REV 001 - Development Copy ND.xlsm