Filter data then copy relevant data to new workbook for each instance

**monkeypants** · 03-13-2016, 09:42 PM

Hi guys,

For each ID number on the attached file, I'm looking to copy and paste the relevant data to a new workbook.

Hoping you can help.

Many Thanks

**YasserKhalil** · 03-13-2016, 10:17 PM

Try this code

Please Login or Register  to view this content.

**monkeypants** · 03-18-2016, 09:18 PM

That's great, thanks very much!

I need to code extended so that it copies the first 8 rows from the total sheet over to every new sheet it creates followed by the results of the filtering.

Existing code is included in the attached file.

Filter data then copy relevant data to new workbook for each instance

LinkBack

Thread Tools

Rate This Thread

Display

Filter data then copy relevant data to new workbook for each instance

Re: Filter data then copy relevant data to new workbook for each instance

Re: Filter data then copy relevant data to new workbook for each instance

Thread Information

Users Browsing this Thread

Similar Threads

My filter isn't grabbing all the relevant data

[SOLVED] as i enter the data in one workbook, it should get updated in relevant other workbook

[SOLVED] VBA code to filter and copy data to new workbook

Macro to filter data and copy to another workbook

Filter on multiple columns without excluding any relevant data

Excel 2007 : search one workbook and paste relevant data in another workbook database

Copy data from different files into 1 workbook under relevant column heading.

Bookmarks

Bookmarks

Posting Permissions