Fetch Data: Return Multiple Rows based on Cell Content

**pdreyest** · 09-23-2012, 01:39 PM

Hi there!

I am posting the example attached. If you see tabs "US" and "Jap" you will see a few users. The raw tab has all the data available. I need a formula/funcion (or even Macro as I cannot wrap my hands around the best way to do this) that will return all the rows based on the users in tabs Jap and US. If you need more info on the case, this is to determine user errors.

**dilipandey** · 09-23-2012, 02:11 PM

Hi pdreyest,

I would suggest you to look into "Advanced Filter" option of Excel.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**pdreyest** · 09-23-2012, 02:29 PM

Hi @dilipandey,

I tried but I'm not getting anything but the users that are on that master list. I need this to return the rows of data if the users are found on that master list. Can you send the steps if you believe this works?

I have about 500 rows word of data and about 50 users on the file I'm working with.

**dilipandey** · 09-23-2012, 02:49 PM

Hi pdreyest,

Here are the steps which I followed .. but using advanced filter you 'll get the data in current active sheet only

Go to advanced filter option, Select the radio button "copy to another location", select the criteria which is there on the sheet "US" (I have included the heading as well in other sheet), now choose the destination under option "copy to" with in same sheet i.e., "RAW" and click on OK.

Regards,
DILIPandey

<click on below 'star' if this helps>

**dilipandey** · 09-23-2012, 02:50 PM

Here is the attachment which I tired..

Test(15).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**pdreyest** · 09-23-2012, 03:28 PM

Not working my friend. It doesnt return anything at all. I was trying to keep it in the same sheet and then eventually paste to the other tabs such as US and Jap in my original file but no luck. Is there any other way?

**dilipandey** · 09-23-2012, 03:33 PM

It worked in my case..if you see the workbook which I have uploaded in post#5, you'll notice the data from row 13 onwards and I got this using advanced filter only. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**pdreyest** · 09-23-2012, 03:55 PM

Hey @dilipandey,

I was not adding the header to Jap or US in my report. When I added to the criteria, worked like a charm. I appreciate your patience and support. BTW - I added a star to your flawless reputation.

**dilipandey** · 09-24-2012, 12:43 AM

you are welcome pdreyest

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

Fetch Data: Return Multiple Rows based on Cell Content

LinkBack

Thread Tools

Rate This Thread

Display

Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Re: Fetch Data: Return Multiple Rows based on Cell Content

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions