Slow down and try explaining it again. At least in my opinion, this
description is meaningless.
Enter what in A2:G2 and the following cell after G2 is H2????
Five cells in a column - what column? Where do they start.
For five cells, it might be easier for you to do it manually.
--
Regards,
Tom Ogilvy
"Angela0212 " wrote in message
...
I am trying to change an excel spreadsheet into something I can download
into our accounting software.
What I am looking for is.......
if H2 is greater than 0, then enter A2:G2 in separate cells, then
enter the H2 amount in the following cell.
I need to do this for up to 5 cells in a column. So if the cell has
2000 in it... I need the cells to the left to show and the original
cell amount. But I don't want the amount of the previous cell.
Help!!!!
---
Message posted from http://www.ExcelForum.com/