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