Linda Berardo
New Member
- Joined
- Mar 19, 2009
- Messages
- 16
I have a worksheet that has over 1,500 rows. I need to copy that worksheet and eliminate rows that don't contain certain values. I would paste an example in this post, but I don't know how to do that. I see others but I can't figure it out. When I tried, it didn't work.
I have a header row with descriptions and the one in column a is Unit. So, lets say I have Unit 0807, 0840, 0501, 0502, 0503, 0601, 0683, etc. So, doing this manually I would copy the whole worksheet and then eliminate the all the rows but those with 0807 in the Unit column. I would do the same for 0840 and so on until I created a separate worksheet for each unit.
I would like to create a macro that will allow me to enter a prompt of the unit number and then eliminate all the other rows. Then, I can either save that worksheet as a separate file or create a workbook with 20 worksheets at a time and then save as a separate file.
FYI, there are close to two hundred units. I may run into a worksheet limitation. But I can deal with that by saving the worksheets into separate workbooks. Or, if you have suggestions for that too, I welcome them!
Thanks for any and all input.
I have a header row with descriptions and the one in column a is Unit. So, lets say I have Unit 0807, 0840, 0501, 0502, 0503, 0601, 0683, etc. So, doing this manually I would copy the whole worksheet and then eliminate the all the rows but those with 0807 in the Unit column. I would do the same for 0840 and so on until I created a separate worksheet for each unit.
I would like to create a macro that will allow me to enter a prompt of the unit number and then eliminate all the other rows. Then, I can either save that worksheet as a separate file or create a workbook with 20 worksheets at a time and then save as a separate file.
FYI, there are close to two hundred units. I may run into a worksheet limitation. But I can deal with that by saving the worksheets into separate workbooks. Or, if you have suggestions for that too, I welcome them!
Thanks for any and all input.
Last edited: