View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gary gary is offline
external usenet poster
 
Posts: 80
Default Aligning related data

I find the cells with '0PAID STATUS" and find the cells with
"0ERRB004" then do INSERT CELLS so these cells are shifted 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 they're on the same row as their corresponding cells with
"0ASMNT-NBR" in Col A?