GETTING THE NUMBERS TO POST ONTO THE NEXT LINE

T

tim lee

I wonder if you would be so kind as to give me a bit of help on posting to
the next line. I have a workbook with sheet1 2 and 3 and on a1 I have accy
a2 10 ;b1 bchgs b2 20; c1 clean c2 30 and so on.

I am trying to get them to post to sheet2 onto the next line. I know, it is
easy enough to denominate a cell like sheet1!a1=sheet2!a1 and so on, but the
lead sheet1 is actually the trial balance and sheet2 the profit and
loss.Where a2 <> 0
this is fine, but where there is no value [for instance bchgs], I dont want
it to list on sheet2. ie I dont want a proforma profit and loss with a whole
lot of zeros in it.

I therefor am anxious to see if using a loop for instance, you can use
perhaps a ctr or using next or skip, it could simply post to the next free
line?

Any help you can give will be more than appreciated.
 
E

E_R

Trying to understand your Q...

You want to copy the values from sheet1 row 2 to sheet2 row 3, as lon
as the cell is not 0
 
F

ForSale

Range("A1").Select

Do

If IsEmpty(ActiveCell) = False Then

ActiveCell.Offset(1, 0).Select

End If

Loop Until IsEmpty(ActiveCell) = Tru
 
T

timothylee

Yes that is correct - I already know how to paste specific cells to specific
cells but I want to list them on the next line omitting any cells from
sheet1 that have nothing in them 0
 
Top