I am trying to change an excel spreadsheet into something I can downloa
into our accounting software.
What I am looking for is.......

if H2 is greater than 0, then enter A2:G2 in separate cells, the
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 ha
2000 in it... I need the cells to the left to show and the origina
cell amount. But I don't want the amount of the previous cell.

Help!!!

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