I've searched all over, and I'm unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet.
Eg, Copy Cells, A10, F2, F3 & F34 from Sheet 1, to A2 in Sheet 2 and start a new row.
The purpose is to copy certain information from an Invoice (Sheet 1)
- A10 - Customer
- F2 - Date
- F3 - Invoice No
- F34 - Total Cost
to a single row in another sheet for reporting (Sheet 2)
When I complete a new invoice, I'm hoping to run the same macro to copy these cells onto the next empty row in Sheet 2.