So I need a macro that will copy data from my "Sheet 1" to my "Sheet 2" then move it down by one cell without moving my formulas as I need to run a report from the data.
I have attached the form I am trying to do this with below.
Sheet 1 is "Submit QA" and sheet 2 is "QA Totals"
on the sheet "QA Totals" I have the boxes that will eventually count the data which appears in the table, but at the moment when I hit submit I am copying the data values (which is what I want) but then its inserting a cell and shifting everything down, I need my formulas to stay where they are.
p.s I'm pretty rubbish at macros lol
Can anyone help?
Bookmarks