Hey guys ,
i have atteched a file..and also i have written the vba code..
i want from sheet1 data if am copying and pasting into sheet2...
if sheet1 a1 to Sheet2 a1
sheet1 a2 to sheet2 a2
but
sheet1 a4 is blank and a5 has text then a5 shoud copy into Sheet2 a4 (need the code )
thank you
Bookmarks