Copying Certain Rows To New Workbook And Saving

[seanpatrickboyd]

Hi all,

I am looking for a way to automate the following task:

To take all rows that have a certain value (Selectable at the start of the operation) in Column I, and copy them to a new Workbook along with Row 1 (Titles for Columns), and then have this new Workbook save, in the same folder as the original file, with its name being the value selected and searched for.

For example:

I would like a prompt on running the macro asking which, "Building Name," I would like to search for and then have it end with all the rows containing that Building name copied to a new workbook saved as "Building Name".xls

I'm a complete novice, so any help in this area would be great. I would attach the file but it contains sensitive data. Thank you very much.

[aydeegee]

Hi seanpatrickboyd

Any help you receive will be far better if you can give an example. If you cannot make your data anonymous, perhaps you could just mock up something?

Regards
Alastair

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[seanpatrickboyd]

Hi,

I have attached a file that is more or less the same as the current worksheet, only much, much smaller.

That solution has managed to create a new file and save it as the value I entered but has only copied across the title row and none of the actual data.

The only columns I actually need copied across are "Item Name", "Last Known User", and "Building Name"

Would it be possible to do this so that it automatically created a different sheet for each different Building Name and then saved them all seperately to their respective names? Or is this a step too far?

Thanks a lot for your help so far.

[JOHN H. DAVIS]

In order for the macro to work you would need to type in the Building Name exactly as it is in the Column. I tested on your sample and it worked.

[JOHN H. DAVIS]

Will the Building Names be sorted as in your sample?