Hi,
I am trying to copy multiple cells from one sheet and paste them into another, I have code to copy them from a single line which is:
Sheets("Input Sheet").Range("A6:H6").Copy
but I am trying to copy and paste the below highlighted range in a specific order as numbered in the highlighted cells (H18 is the last one to be copied)
they are being pasted into the following table called "invoices", the sheet is also called invoices.
thanks in advance
I am trying to copy multiple cells from one sheet and paste them into another, I have code to copy them from a single line which is:
Sheets("Input Sheet").Range("A6:H6").Copy
but I am trying to copy and paste the below highlighted range in a specific order as numbered in the highlighted cells (H18 is the last one to be copied)
they are being pasted into the following table called "invoices", the sheet is also called invoices.
thanks in advance