Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data from one sheet to another automatically
I have a massive list of raw data that I am wanting to put into individual
sheets. i.e All those rows that start in column A with Powercar1 into sheet called Power, same for WaterCar1 into Water etc. Snip it below of data Is this possible.....I've had a look at the forum and can't find any clues to help me. If I put a formula into the first column of each sheet to lookup the reference, I get the same data repeated...........it does not bring each in. If necessary data can be added to the raw data if it helps putting it into seperate sheets. Please help Column A Column B Column C POWERCAR0 36 WF05XXGBB56T88939 POWERCAR0 36 WF05XXGBB56T89898 BTCAR0 35 WF05XXGBB56T89963 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y39111 WATERCAR1 117 WF05XXGBB56Y39978 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y40092 POWERCAR1 111 WF05XXGBB56Y45247 POWERCAR1 96 WF05XXGBB56Y48127 AFFILIATESCAR1 106 WF05XXGBB56Y48299 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data from one sheet to another automatically
Why not Sort followed by Copy and Paste?
Or is it truly 'massive'? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "holyman" wrote in message ... I have a massive list of raw data that I am wanting to put into individual sheets. i.e All those rows that start in column A with Powercar1 into sheet called Power, same for WaterCar1 into Water etc. Snip it below of data Is this possible.....I've had a look at the forum and can't find any clues to help me. If I put a formula into the first column of each sheet to lookup the reference, I get the same data repeated...........it does not bring each in. If necessary data can be added to the raw data if it helps putting it into seperate sheets. Please help Column A Column B Column C POWERCAR0 36 WF05XXGBB56T88939 POWERCAR0 36 WF05XXGBB56T89898 BTCAR0 35 WF05XXGBB56T89963 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y39111 WATERCAR1 117 WF05XXGBB56Y39978 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y40092 POWERCAR1 111 WF05XXGBB56Y45247 POWERCAR1 96 WF05XXGBB56Y48127 AFFILIATESCAR1 106 WF05XXGBB56Y48299 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data from one sheet to another automatically
I'm trying to automate it to remove the possibility of things going
wrong...the report i'm working on has formulas linking to other sheets, so am following the trend and setting up the report to be automatic. THe number of rows can be anywhere between 5000 and 30000. "Bernard Liengme" wrote: Why not Sort followed by Copy and Paste? Or is it truly 'massive'? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "holyman" wrote in message ... I have a massive list of raw data that I am wanting to put into individual sheets. i.e All those rows that start in column A with Powercar1 into sheet called Power, same for WaterCar1 into Water etc. Snip it below of data Is this possible.....I've had a look at the forum and can't find any clues to help me. If I put a formula into the first column of each sheet to lookup the reference, I get the same data repeated...........it does not bring each in. If necessary data can be added to the raw data if it helps putting it into seperate sheets. Please help Column A Column B Column C POWERCAR0 36 WF05XXGBB56T88939 POWERCAR0 36 WF05XXGBB56T89898 BTCAR0 35 WF05XXGBB56T89963 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y39111 WATERCAR1 117 WF05XXGBB56Y39978 GOVERNMENT DEPARTMENTSCAR1 117 WF05XXGBB56Y40092 POWERCAR1 111 WF05XXGBB56Y45247 POWERCAR1 96 WF05XXGBB56Y48127 AFFILIATESCAR1 106 WF05XXGBB56Y48299 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |