macro to add invoice no in summary invoice sheets

[JEAN1972]

I have a macro that copy all workbook sheet invoices to summary invoice sheet.

The invoice no is always at A16 on all sheets .

Looking a macro to add the invoice no to summary invoice sheet in column A that is add header and the corresponding invoices as per their respective sheets .

The actual macro copies all data except the invoice no .

Please Login or Register  to view this content.

[jindon]

See if this is how you wanted.

Please Login or Register  to view this content.

[JEAN1972]

Thank you Jindon



working perfectly but just an insight there is a specific sheet tab named CREDITNOTE , the code should ignore that tab when it copies .

Could you adjust

Thank you for assistance .

[jindon]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

These comparison are Case Sentive...

[JEAN1972]

Thank You Jindon

Perfect

[jindon]

You are welcome and thanks for the rep.