Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy specific data form sheets into master sheet | Excel Worksheet Functions | |||
Other sheets to pick data from master sheet | Excel Discussion (Misc queries) | |||
Updating indivudal sheets thru a Master sheet | Excel Discussion (Misc queries) | |||
Moving data from master sheet to new sheets | Excel Worksheet Functions | |||
Extracting cell information from various sheets to a master list | Excel Discussion (Misc queries) |