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 sheet.
What would be perfect is if there is anyway I can easily send each sale
to a salespersons sheet and the new or used tally sheet 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: www.excelforum.com/member.php...oamp;userid=18538
View this thread: www.excelforum.com/showthread...hreadid=497426Hi
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
peltiertech.com/Excel/Pivots/pivotstart.htm
www.contextures.com/xlPivot02.html--
Regards
Roger Govier
foamcows gt; wrote:
gt; I have a main page where I want to insert all the sales for every
gt; salesperson, all the information for the sale on one page to
gt; streamline reporting sales. This information would then be linked to
gt; the corresponding salesperson and reported in a new or used tally
gt; sheet. What would be perfect is if there is anyway I can easily send
gt; each sale to a salespersons sheet and the new or used tally sheet
gt; without having to retype everything or relink it.
gt;
gt; I have thought of giving each sale a id number and doing a vlookup for
gt; all the fields on that id to pull everything. I just want to know if
gt; anyone knows of a better way where I will not have to go into the
gt; salespersons/newused page to enter the sale id number. I am trying to
gt; avoid having to go into multiple pages to report one sale, to cut down
gt; on possible entry errors.
gt;
gt; essentially, is there anyway to push information into different lists
gt; when it is entered on a mail list. I know excell can pull, but in this
gt; case I almost need to push it.
gt;
gt;
gt; --
gt; foamcows
gt; ------------------------------------------------------------------------
gt; foamcows's Profile:
gt; www.excelforum.com/member.php...oamp;userid=18538 View
gt; this thread: www.excelforum.com/showthread...hreadid=497426
