Need Help pulling information from one sheet to another sheet

**tht9015** · 10-31-2013, 05:02 PM

I have a spreadsheet that reflects the names of Sales Reps and Companies that they've done business with. Each month I must send each of the Sales Reps a copy of only "his/her" sales. I was trying to use the vLookup functions so that it can search for a specific Sales Rep and populate only his/her sales information into another tab of the same document. This is done monthly so each month the tab for Sales Reps will be the same and only the data on the initial document page is modified. Is there a VLookup function or a VBA/Macro Code that I can implement that will only pull the information for each Sales Representative into his/her respective Worksheet? I can use the help with this. Attached is a spreadsheet that can give you idea of what I'm trying to do.

TriedVLookup.xlsx

**alansidman** · 10-31-2013, 05:21 PM

Using the existing table. Put your cursor in the header row and click on the ribbon tab Data. Click on the Icon for Filter.

In the column for the salesman, select the first salesman and then ok. It will filter for that person. Copy and paste to the sales person sheet. Repeat for the next sales person, etc.

**tht9015** · 11-05-2013, 05:58 PM

Sorry, this won't help me... I have hundreds of line of data that is done monthly, sometimes weekly and needed something that could work automatic. I've used "Filter" in the past but it takes tooooooo long. Someone told me that a VBA or Macro would solve my problem and although I've been toying with it I can't seem to get itto do what I want.

**AlKey** · 10-31-2013, 05:24 PM

I would suggest to use PivotTable

Please see attached file

**FDibbins** · 10-31-2013, 05:30 PM

Administrative Note:

We would love to help you with your query, but first, before we can proceed…
Please see Forum Rule #1 about proper thread title
Please PM me when complete (Also, include a link to your thread - copy from the adress bar) and this post will be removed which will reset the replies to zero…

Your thread title should describe your problem, not what you think might be the sollution

To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

**tht9015** · 11-05-2013, 06:22 PM

Sorry. I was trying to give clear picture of what I needed help in and did not want to have responses of things I've may have already tried.

**AB33** · 10-31-2013, 05:32 PM

a VBA solution.

**tht9015** · 11-13-2013, 10:45 AM

Can you tell me what formula you're using in this spreadsheet. I've tried looking through but I'm unclear how you were able to move the data from one spreadsheet to the other.

**tht9015** · 11-13-2013, 02:11 PM

I'm using this formula in my spreadsheet but for some reason it's not pulling the information. I think it has something to do with the brackets I'm using,

I have multiple sales reps and I'm trying to separate their data into their own specific spreadsheet off of a master that has all of them in them. Once they are separated the sales rep can monitor only his/her spreadsheet.

I think this formula should work but for some reason it won't pull the information from the other spreadsheet and all it does is displays the formula

{=+INDEX(INDEX('Web Inventory Log'!$A$4:I161,MATCH($A$1,INDEX(('Web Inventory Log'!E4:E162),0),0),0),SMALL(IF('Web Inventory Log'!$E$4:$E$162=$A$1,COLUMN('Web Inventory Log'!$A$4:$I$4)-COLUMN('Web Inventory Log'!$A$4)+1),COLUMNS($A$2:$A$2)))}

**AB33** · 10-31-2013, 05:34 PM

Sorry FDibbins!
I did not see you post.

**AB33** · 11-05-2013, 06:08 PM

Did you try post no 5? It is a fast code.

**AB33** · 11-05-2013, 06:46 PM

If you have tried similar code to mine, I would like to see it and then should be able to see your picture. I am not a mind reader.

**FDibbins** · 11-06-2013, 12:38 AM

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Need Help pulling information from one sheet to another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need Help pulling information from one sheet to another sheet

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Need Help pulling information from one sheet to another sheet

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Re: Tried VLookup but think I need VBA/Macro Code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Row delete macro is effecting record count formula and vlookup code. #REF!

Row delete macro is effecting record count formula and vlookup code.

[SOLVED] Unlimited Range for VlookUp in Macro Code

Optimizing the Vlookup code in VB. Repitive code with different referencing range.

VLOOKUP macro/VBA Code

Bookmarks

Bookmarks

Posting Permissions