Copying and pasting values to the last available column
 

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

Copying and pasting values to the last available column
 

sanjay,

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

Dennis

"sanju" wrote in message
...
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

Copying and pasting values to the last available column
 

On Mar 18, 1:20*pm, "Dennis Tucker" wrote:
sanjay,

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

Dennis

"sanju" wrote in message

...



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- Hide quoted text -

- 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