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

"sanju" <(E-Mail Removed)> wrote in message
news:55748166-7012-4f03-a05d-(E-Mail Removed)...
> 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
>
>
>

On Mar 18, 1:20*pm, "Dennis Tucker" <dennis13...@cox.net> wrote:
> sanjay,
>
> Is the column EA, Eb, EC... and so on the last used column + 1??
>
> Dennis
>
> "sanju" <sun...@gmail.com> wrote in message
>
> news:55748166-7012-4f03-a05d-(E-Mail Removed)...
>
>
>
> > 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