formula help, sorting information

[foamcows]

I have a main page where I want to insert all the sales for ever
salesperson, all the information for the sale on one page to streamlin
reporting sales. This information would then be linked to th
corresponding salesperson and reported in a new or used tally sheet
What would be perfect is if there is anyway I can easily send each sal
to a salespersons sheet and the new or used tally sheet without havin
to retype everything or relink it.

I have thought of giving each sale a id number and doing a vlookup fo
all the fields on that id to pull everything. I just want to know i
anyone knows of a better way where I will not have to go into th
salespersons/newused page to enter the sale id number. I am trying t
avoid having to go into multiple pages to report one sale, to cut dow
on possible entry errors.

essentially, is there anyway to push information into different list
when it is entered on a mail list. I know excell can pull, but in thi
case I almost need to push it

 

[Roger Govier]

Hi

Try using a Pivot Table.
Make the Salesperson a Page Field, then you can get a report for each
Saleperson on a separate sheet.

For more information on setting up Pivot Tables take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html