extracting data from master sheet into sub sheets and automatic updating.

**samrashia** · 01-16-2012, 10:41 PM

I have a master work sheet which contains the information of various brokers. the fields are agents, customer, primary status , secondary status. there are different number of rows for each agent/broker.what I want is to create sheets for each agents, separately,pulling just his information into new sheet. and link that sheet with master sheet such that every time master sheet is updated , the agent sheet is also updated. the sample data for master sheet is as follows,
Agent: AB
DF, DQ...

Customer: ABS, ABB....
PRimary status : ACCepted, Rejected....
2nd Status: reason, problem.....
I want to extract AB's Info into sheetAB, DF's info into sheetDf and so on. Will be really greatful if you can help me with this.
Samrashia

**arlu1201** · 01-17-2012, 04:44 AM

Instead of putting in dummy data in the post, why dont you attach the sample files? It will be easier and faster to work out a solution for you.

**samrashia** · 01-17-2012, 08:27 AM

Hi,

Thanks for the reply. I am attaching the sample file. The first sheet NPGLDT is master sheet with multiple records of each agent.Second sheet GLD is which is a lookup table for the master sheet to extract agent id's. I want to pull all data of AR into his sheet, such that when i Update Master sheet, it is automatically updated, and I want this for each agent.I am .trying to resolve this for few days and I am really stuck. will be really great full if you can help me with this.

samrashia

**samrashia** · 01-18-2012, 07:31 AM

Hi,

no help ?

**arlu1201** · 02-06-2012, 07:12 AM

I can provide you a macro that you can click on once you are done updating the main sheet. It will automatically clean up the data that is existing in the agent sheets and populate with fresh data from row 1 of the master file till the last row. Will this work?