Grouping cells by different key numbers (2003)

C

Cram

New Member
Joined
Feb 26, 2008
Messages
44
I think that this is very complicated but I'll put it out there.

I want to group rows by a number it may (or may not have) in column E.

For example, all rows in sheet 'Raw Data' that have 'QC23321' somewhere in column E must be copied and pasted to another sheet, say 'Code Groupings'. This is tricky because the 'QC#' is not always in the same place or in the same format. It can be anywhere within a larger string in E and may be QC#, QC # or QC-#.

I have managed to extract all QC #'s, eliminating duplicates and reformatting them to QC # and pasted them as a simple list on another sheet 'QC's'. My original thought was to use this list as a reference to search the sheet and C & P'ing any matches but I hurt my head trying to do so. This may be of no use in any suggested solutions, i don't know.

I can't post an attachment yet so i'll try and clarify any queries.

Thanks
Marc
 
Sort by date Sort by votes
Let me put it another way:

I've been thinking about this over night and i think i can explain it better.

On my sheet 'QCs' I have a list of 4 digit numbers (column A) i.e.

5542
4441
5412
5447
etc

On my sheet 'Raw Data' I have rows of data and somewhere in row E there should be a number that matches one from the list of numbers in 'QCs' i.e

A | B | C | D | E
TestDataNon | 12/04/08 | 13.21PM | Joe Bloggs | Set Up Int QC 5542
DataCleanUp | 19/02/08 | 12.21PM | Joe Bloggs | Set Up Int QC 4441


The output from this I need is to display, on a new sheet, groups OF all rows in 'Raw Data' which have the same QC number which will look something like

5542
DataCleanUp | 19/02/08 | 12.21PM | Joe Bloggs | Set Up Int QC 5542
EditNewClass | 11/02/07 | 19.43PM | Joe Bloggs | Max No Pa QC 5542
TestDataNon | 12/04/08 | 13.21PM | Joe Bloggs | Set Up Int QC 5542

4441
DataCleanUp | 19/02/08 | 12.21PM | Joe Bloggs | Set Up Int QC 4441
EditNewClass | 11/02/07 | 19.43PM | Joe Bloggs | Max No Pa QC 4441
TestDataNon | 12/04/08 | 13.21PM | Joe Bloggs | Set Up Int QC 4441

etc


I hope this explains it better.

I have posted this on another site and I will keep both sides up to date so no one wastes their efforts http://www.excelforum.com/showthread.php?t=637766

Thanks
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Creating a form based on cell values and predetermined layouts
Replies
3
Views
166
mummbles74
M
N
  • Question Question
Locate Cell and enter corresponding value into new cell
Replies
3
Views
209
myall_blues
myall_blues
L
  • Solved
Copying user selected rows to different workbook and under matching columns
Replies
5
Views
395
LaTwiglet85
L
T
  • Question Question
VBA to copy over manual entry cells that are adjacent to imported data
Replies
0
Views
688
TheGrandPooba
T
L
  • Question Question
How to group small variations on data
2 3
Replies
22
Views
1K
awoohaw
awoohaw

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top