1 Workbook - Need to copy data to differant sheets

[mroldguy]

Hello everyone,
I have a workbook (Sheet 1 contains - 6 columns and 1000's of rows). Column B has sensor type. Is there away to copy all data the deals with each sensor and paste it on a new sheet in the same workbook and name these new sheets by sensor type

Example
Date Sensor IP Address DNS Error
1/1/2014 Unix 1.1.10.10 fatty clock error
1/1/2014 HP 1.1.2.3 slim power isues


Please note I have over 50 sensor types.

Thanks in advance for your help

[David A Coop]

Hi Mr Old Guy,

This can be done quite easily.

Two questions:

1 Will each new sheet have the same headings as your data sheet, and the same six columns?
2. Will the Sensor data be "all over the place" or sorted so that it is all together?

If you like to post a workbook with more that two rows in it, I can drop a macro into it rather than making one up from the small amount of data you provided.

Regards,

David (probably an older guy!)

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[mroldguy]

For Daqvid A Coop

Hi David I attached file. Please not that this is dummy data as my work PC is locked down and I can't RDT between my 2 machines. Also the work I do is in excel 2003.

The column I am looking at is "B" and would like the sheet1 to be the same afterwards. I can sort it by before running macro.

Thanks for your help on this!

[AB33]

Try the attached.

[mroldguy]

THANKS AB33 - This worked GREAT!