Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if a cell is 0, how do I select a range of cells?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if a cell is 0, how do I select a range of cells?
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
if a cell is 0, how do I select a range of cells?
Okay, let me try again.
I have a spreadsheet. There are 10 columns. I am trying to move onl parts to a second sheet. The first 5 columns are mandatory. The next 5 columns may or may no have a dollar amount in them. So for one row, I could have 5 dolla amounts for one description (the first 5 columns). So what I am trying to do is break it down line by line. Say the firs non mandatory column has $10, what I need is to be able to have th mandatory codes copy to another sheet along with the dollar amount Then the second non mandatory column could have a $$ amount in it and want it to pull the mandatory columns and that dollar amount but no the first. Does that make more sense -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select range of cells from A1 to last cell with data? | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
using cell values to select range of cells | Excel Programming |