Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I find the cells with '0PAID STATUS" and find the cells with
"0ERRB004" then do INSERT CELLS so these cells are shifted right into Col B. Then, in Col B, I delete the top three empty cells so the first cell with "0PAID STATUS" is on the same row as its corresponding cell with "0ASMNT-NBR" in Col A. However, the subsequent cells with "0PAID STATUS" or "0ERRB004" in Col B are NOT on the same row as their corresponding cells with "0ASMNT-NBR" in Col A. How can I get the cells with "0PAID STATUS" or "0ERRB004" in Col B moved up so they're on the same row as their corresponding cells with "0ASMNT-NBR" in Col A? Then, how can I get the cells in each "group" in Col C moved up so the first cell in each "group" is on the same row as the corresponding cells in Col A and Col B? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
aligning data | New Users to Excel | |||
ALIGNING TWO ARRAYS OF DATA VALUE | Excel Worksheet Functions | |||
aligning data | Excel Programming | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
Aligning rows of data | Excel Programming |