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.
--
TIM LEE tax agent 55 807 001
4a/123 Colin St West Perth 6005
Tel 08 9481 0337 Fax 9321 0036

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

--
Message posted from http://www.ExcelForum.com

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
"E_R " wrote in message
...
Trying to understand your Q...

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


---
Message posted from http://www.ExcelForum.com/

Range("A1").Select

Do

If IsEmpty(ActiveCell) = False Then

ActiveCell.Offset(1, 0).Select

End If

Loop Until IsEmpty(ActiveCell) = Tru

--
Message posted from http://www.ExcelForum.com