Create a worksheet from results of the whole workbook (multiple sheet filtering)

**ralfaia** · 02-18-2015, 01:47 PM

Hi everyone,

I have a workbook, with multiple Sheets ('2015', '2014' ...'2006') with the same structure in all of them. When I do a 'Find' and look for a customer Name in the whole workbook, sometimes the list of results is big. I would like to generate a sheet, by copying the entire row of every result. I mean, copying the row where customer FORD appears in sheet 2015, 2011, 2008 to a new sheet. I would have then a sheet only with FORD Information. It's like a multi-tab filtering. Any ideas ? Thanks, Rodrigo.

**davesexcel** · 02-18-2015, 01:49 PM

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**JOHN H. DAVIS** · 02-18-2015, 03:07 PM

Maybe:

Please Login or Register  to view this content.

Create a worksheet from results of the whole workbook (multiple sheet filtering)

LinkBack

Thread Tools

Rate This Thread

Display

Create a worksheet from results of the whole workbook (multiple sheet filtering)

Re: Create a worksheet from results of the whole workbook (multiple sheet filtering)

Re: Create a worksheet from results of the whole workbook (multiple sheet filtering)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Create single worksheet from multiple workbooks with 4 worksheets in each workbook

Create list in new worksheet with current info after multiple filtering

script to create csv file from a worksheet in a multi-sheet workbook

Automate filtering of multiple lists and transposing results onto another worksheet

[SOLVED] How can I create multiple rows of worksheet tabs in a workbook?

Bookmarks

Bookmarks

Posting Permissions