vLookup - how to pull data from a sheet to other sheets ...

[angelandgreg]

ok, i have an excel sheet where the first sheet is a data link to pull several columns as a data dump.

It has all the reps info on it.

What I need to do is on the next sheet have it look up from the data dump sheet the specific rep and pull all the columns of data into this next sheet and so on to other sheets for each change in rep.

it would be great if each sheet updated the data from the data dump sheet after it is refreshed.

it would also be great if each sheet (which is per rep) can lookup for that specific rep each time.

I hope this made sense??


Data Dump example:
REP Customer YTD Sales PTD Sales PVR Sales
tony 123 5000 500 20000
tony abc 400 0 300
bob 345 4000 400 10000
bob xyz 3000 200 0

next sheet: (which would be the 2nd sheet as the data dump is the first sheet in this worksheet)
REP Customer YTD Sales PTD Sales PVR Sales
tony 123 5000 500 20000
tony abc 400 0 300


3rd sheet:
REP Customer YTD Sales PTD Sales PVR Sales
bob 345 4000 400 10000
bob xyz 3000 200 0

 

[angelandgreg]

Hi,
well, i tried to do this but it doesn't seem to be doing anything?

I am new at this. I have never worked with Macros in Excel.