Copying and pasting values to the last available column

  • Thread starter Thread starter sanju
  • Start date Start date
S

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
 
sanjay,

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

Dennis







- Show quoted text -
Click to expand...

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
 
Back
Top