Re: formula help, sorting information

Hi

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

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


--
Regards

Roger Govier



foamcows <foamcows.2111xn_1136238906.8698@xxxxxxxxxxxxxxxxxxxxx> wrote:
> I have a main page where I want to insert all the sales for every
> salesperson, all the information for the sale on one page to
> streamline reporting sales. This information would then be linked to
> the corresponding salesperson and reported in a new or used tally
> ***. What would be perfect is if there is anyway I can easily send
> each sale to a salespersons *** and the new or used tally ***
> without having to retype everything or relink it.
>
> I have thought of giving each sale a id number and doing a vlookup for
> all the fields on that id to pull everything. I just want to know if
> anyone knows of a better way where I will not have to go into the
> salespersons/newused page to enter the sale id number. I am trying to
> avoid having to go into multiple pages to report one sale, to cut down
> on possible entry errors.
>
> essentially, is there anyway to push information into different lists
> when it is entered on a mail list. I know excell can pull, but in this
> case I almost need to push it.
>
>
> --
> foamcows
> ------------------------------------------------------------------------
> foamcows's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=18538 View
> this thread: http://www.excelforum.com/showthread.php?threadid=497426


.