Copying and pasting values to the last available column

[sanju]

I need to update daily stautus to the particular column of the
worksheet. Now these values are updated daily in column 22 of
worksheet.
For today , copy values of acolumn 22 to EA.
tomorrow, copy values of column 22 to EB
day after , copy values of column 22 to EC and so on

regards
sanjay

 

[Dennis Tucker]

sanjay,

Is the column EA, Eb, EC... and so on the last used column + 1??

Dennis

 

[sanju]

sanjay,

Is the column EA, Eb, EC... and so on the last used column + 1??

Dennis







- Show quoted text -

There are some blank column inbetween which I have kept hidden.
So EA onwards will be last visible blank column .
In fact I have all my calender mapped from column EA onwards .

regards
sanjay