GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
 

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

GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
 

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

GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
 

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

GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
 

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/