Copy data from several ranges to new sheet

[jpruffle]

Hi,

I am working on a spreadsheet that enables calls to be monitored for QA. The first sheet enables the user to enter data, then a button can be used to submit the data which should place it in the 'Data' sheet with each submission entered on a new row. As the data being entered is in several different ranges I cannot get the next set of data entered onto the next row on the 'Data' sheet, can you advise please? My code is below and I've attached the workbook.

Thank you in advance. JP

Please Login or Register  to view this content.

[p24leclerc]

See attached workbook for a modified working macro.
I deleted the merged cells as it was creating problems witht the macro.
Most of the time, it is best to use the Center across selection of cell's aligment format
instesd of merging cells.
Here is the modified macro:

Please Login or Register  to view this content.

It would be a good thing to have the macro erase the cells in the QM Form so the users starts with a fresh sheet.
Hope this helps