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 |
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 |
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 |
All times are GMT +1. The time now is 02:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com