| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula locates common data in a cell and drops them in other shee
I have a spread sheet with a range of data from columns A - I.
The number of rows always varies. In column G there is a number or reference followed by a a group of letters. examples below, 123456HYPER ABCD01PC01AA ABCD01PC01PR I need a formula that locates the 'HYPER' of all cells of column G that contain HYPER and drop it with the corresponding contents of cells A - I into a seperate sheet2. the other formula of sheet3 would pick out the 'AA' in column G and drop it and the corresponding details into sheet3 The formula for sheet 4 would pick out the 'PR' in column G and drop it and the corresponding details into sheet 4. In this case then the data would essentially be sorted from sheet1 and dropped into sheets 2 3 and 4. is this possible? any help would be much appreicated! Regards Barry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to pick out common parts of a cell and drop them in new sh | Excel Discussion (Misc queries) | |||
| How can I insert the tab name into a cell in a different shee... | Excel Discussion (Misc queries) | |||
| Combining rows of data that have one cell in common | Excel Discussion (Misc queries) | |||
| Hyperlink Locates file regardless of it's location | Excel Discussion (Misc queries) | |||
| Copy Formula But Keep 1 Common Cell | Excel Discussion (Misc queries) | |||
Threaded Mode
