Macro copying number to the wrong column. Please help me fix it?

[celeazul]

Hi,
I was wondering if someone can help me.
At the moment the most of the macros on this spreadsheet are working fine.
However, when I filter the Revenue Report tab (yellow tab) by confirmed, and then go to the black tab (invoice audit) and press the copy from yellow tab button, it copies most of the data correctly.
However there is something its doing incorrectly.
One of the columns thats copying over, is copying it incorrectly. Here's what it should do...
I need that whatever is in column J on the yellow tab (Revenue Report), to copy to column I on the black tab (invoice audit).
Can you please help?
Thank you in advance.
Cele

[antoka05]

See attached file, I hope that it's what you need.

Regards,
Antonio

[Richard Buttrey]

You are making life more difficult by not having the same column labels in the two sheets and by not using the same layout. For instance in the renewal report there is no column for Qty which is in column H of the Invoice Audit sheet.

If you change the name of column H on the Audit sheet to "Final Order Amount" and then delete Column I which currently is the Difference column from the yellow tab then your data will be correct.

However as I say if you want to do stuff like this you'd be far better using an Advanced Data Filter in a macro.

[LeoTaxi]

Like this it is correct

Please Login or Register  to view this content.

Kind regards
Leo

[celeazul]

Almost Antonio. The thing is with the blank rows up at the top, if left blank, then it does this correctly. But when I attemped to remove the blank rows at the top, it moved everything over, one column. Is there anyway to fix that?

[celeazul]

Leo, you got it!!! Thanks so much

[celeazul]

Antonio, quick question for you...
Is there anyway you can keep the column label Qty on the Invoice Audit tab? Meaning that it doesnt copy that data from the Renewal Report tab?

[Richard Buttrey]

Hi,

...as I suggested earlier use a Data Filter Advanced (in a single line macro) and avoid unecessarily complicated vba code and loops which will be much slower with large ranges.

[Richard Buttrey]

Hi,

...as I suggested earlier use a Data Filter Advanced (in a single line macro) and avoid unecessarily complicated vba code and loops which will be much slower with large ranges.