Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ARRANGE COLUMN AND COPY ON THE OTHER COLUMN | New Users to Excel | |||
Copy Unique Record | Excel Discussion (Misc queries) | |||
Macro Search and Copy between Cells with unique data | Excel Discussion (Misc queries) | |||
Excell 2007: How to arrange cells in a column file alphabetically? | Excel Discussion (Misc queries) | |||
How do I arrange a formula between cells that are not together? | Excel Worksheet Functions |