How to copy one column values to another column based on condition that row2 contain

Hi

I am struck up in my code and getting error. It is pretty simple one.


I have to copy values from column 32 row 3 onwards i.e. cell (x,32) to
column C row 3 onwards i.e. cell(x, C).
Column C is column whose row 2 contain today's date.


I hope I am clear. To simplify this I am taking an example:-


If cell (2,45) contain todays date then copy all cells(3 onwards, 32)
to cells(3onwards,45).
If cell(2,50) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,45).
If cell(2,100) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,100)
If cell(2,200) contain todays date then copy all cells(3onwards,32) to
cells(3onwards,200)


If anything is unclear, please let me know so that I can send you the
file.


Regards
San

Hope this helps...

Please Login or Register  to view this content.