Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Copy and arrange cells in unique way

I am starting an excel file that extracts file from another worksheet,
then after it is extracted, A4 cell has a value in cell B4, I wanted
to copy all the cells in column A&B to column D&E in such a way that
when the word "check is encountered in column A, it will arrange
itself in the last with the other cells that contain same words before
the word "check". I wanted to do this in macro or formula if possible.
I have tried to look in the forums but I can't find a closer solution
to this. The problem on this is that Column A&B are changing and only
the word "check" is constant in some cells. Please help..Can anyone
please help me on these..
This a what I wanted to do:

A B D
E
EFFECT - ARRANGED
Description Weight Description Weight

GO1 0.5 GO1 0.5
GO2 0.4 GO2 0.4
MO1 0.7 GO1 CHECK 0.7
MO2 0.9 MO1 0.7
FO1 0.8 MO2 0.9
FO2 0.9 FO1 0.8
TO1 0.6 FO2 0.9
TO2 0.8 FO1 CHECK 0.7
GO1 CHECK 0.7 TO1 0.6
FO1 CHECK 0.7 TO2 0.8
Reply
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
ARRANGE COLUMN AND COPY ON THE OTHER COLUMN GEOFF New Users to Excel 3 September 25th 09 10:28 AM
Copy Unique Record Kim Excel Discussion (Misc queries) 2 August 27th 09 07:35 PM
Macro Search and Copy between Cells with unique data david@damprodu Excel Discussion (Misc queries) 2 March 6th 09 12:40 PM
Excell 2007: How to arrange cells in a column file alphabetically? Vince Excel Discussion (Misc queries) 10 December 5th 08 01:33 AM
How do I arrange a formula between cells that are not together? Jo Fox Excel Worksheet Functions 4 January 23rd 07 01:12 AM


All times are GMT +1. The time now is 07:05 PM.

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"