Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multilayered Spreadsheet Function
Is there a way to take a Main spreadsheet that has the sales data and take
that data and allocate it to individual regional sales sheets as the data is being entered? For instance, there are 25 Regions nationally and each phone call is logged onto the main sheet. Each of the 25 Regions need to know the data of each of the calls that phone in; so is there a way to do this? I would appreciate any help that I can get. Sincerely - Ali14 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multilayered Spreadsheet Function
Hi,
You may refer to question 7 on the following link - http://ashishmathur.com/knowledgebaseII.aspx -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ali14" wrote in message ... Is there a way to take a Main spreadsheet that has the sales data and take that data and allocate it to individual regional sales sheets as the data is being entered? For instance, there are 25 Regions nationally and each phone call is logged onto the main sheet. Each of the 25 Regions need to know the data of each of the calls that phone in; so is there a way to do this? I would appreciate any help that I can get. Sincerely - Ali14 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet function | Excel Worksheet Functions | |||
Spreadsheet Function | Excel Worksheet Functions | |||
'name of spreadsheet' function... please help | Excel Worksheet Functions | |||
Spreadsheet Function | Excel Worksheet Functions | |||
spreadsheet function | Excel Discussion (Misc queries) |