LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
aligning data carl669 New Users to Excel 6 March 3rd 09 07:34 AM
ALIGNING TWO ARRAYS OF DATA VALUE sunan Excel Worksheet Functions 1 June 21st 08 05:08 AM
aligning data [email protected] Excel Programming 2 September 21st 06 05:17 PM
Aligning decimal numers to the centre of the cell and aligning dec Ramesh Babu Excel Discussion (Misc queries) 1 July 1st 06 10:33 PM
Aligning rows of data e abor Excel Programming 1 June 22nd 06 08:10 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"