Copy cells from one sheet to another

Couldn't you just use a simple formula, e.g. for Financial Element (in D2)

=Data!L4

etc? Why not just hide columns rather than duplicate your data?

Originally Posted by StephenR

Couldn't you just use a simple formula, e.g. for Financial Element (in D2)

=Data!L4

etc? Why not just hide columns rather than duplicate your data?

yes that will be the easy method, but the real raw data file is over 6000 rows and more than 12 customers, i want to divide each customer into one sheet hence the macro.

Is an easier way to report each customer aging time and category which is the objective of the file. the aging time and category are displayed vertically in the raw data but i want to transposed that to be horizontally on the report sheet.