sheet1 to sheet2

Microsoft Excel 2003 (full product)
August 26, 2010 at 18:29:47
Specs: Microsoft Windows XP Professional, 2 GHz / 958 MB
i already have a macro for this and it is working..

like for example in values in Sheet1 cell C4:C8 will be transferred to SHeet2 cell A2:E2 then I will clear what I have in Sheet 1 and have a new value in Sheet1 C4:C8 and will again transfer it to Sheet2 but this time it should be in A3:E3.

my problem is..
what if my first record in Sheet1 C4 is an empty cell and C5:C8 has values in it. This is okay to tranfer in Sheet2 A2:E2 but for my second record C4 now has a value. When I transfer it to Sheet2 it was paste to A2 but it should be in A3.

make sense? please help..


See More: sheet1 to sheet2

August 26, 2010 at 18:59:40
this is what I mean

Sheet 1 (First Record)
Col C
Row 4 <empty>
Row 5 CPU
Row 7 <empty>
Row 8 20000221

Sheet 1 (Second Record)
Row 4 Help
Row 5 COMP
Row 6 OVER
Row 7 8/25/2010
Row 8 2221

Sheet 2
Col A Col B Col C Col D Col E
Row2 <empty> CPU OLIVETTI <empty> 20000221
Row3 Help COMP OVER 8/25/2010 2221

When I run my macro what happen is that Row2 was overwrite by the new record.



Report •
Related Solutions

Ask Question