Multilayered Spreadsheet Function
in [Functions]
|
Prev: Excel - Ignoring the contents of cells when there are letters in the cell
Next: Relative Reference in Conditional Formattin
From: Ali14 on 20 Jan 2010 18:27 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
From: Ashish Mathur on 20 Jan 2010 20:51
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" <Ali14(a)discussions.microsoft.com> wrote in message news:D3D928FD-5497-4EC4-A1E3-6637D7C8E5C9(a)microsoft.com... > 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 |