Coding for Copying data

[mohan08]

Hi All,

Need help on creating macro to copy data from last used column(Can be from C to CA) and update in Column CC.
the Workbook may contain 2 sheet to 20 Sheet, Can you please help with Coding which will capture the last used column in each sheet to CC

 

[vletm]

Aren't CC in You case always the last used column?

 

[mohan08]

Hi Vletm, We want CC as the last column used since we have files with updated upto Column CA

 

[vletm]

For me ... the last column used is the most right side column, which has something ... eg Your named CC ( or could be something else after CC too ).
You skip to mention/verify:
... is Your the last column used ... the column, which has used (~modified) the last time ... eg cell G12 from G-column.
... but same time, there could be data in AA-column ( used eg two weeks ago )
Which column G or AA should copy to CC-column?
My sample will ... clear old data from CC-column and after that it will copy AA-column to CC-column.
It will copy only data from 1st row to the last row, which has data in that column.
Usage: Press [ Do It ]-button