If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering Data
I have an Excel spreadsheet which contains the part numbers and prices from
our official price list and from orders received from customers. I need to determine if the customer has used the correct price on their order. The spreadsheet has 2 columns, price & part. I'd like to set up my merge such that if the part & price match the next record, those records are skipped. For example, in the spreadsheet below, only the last item would show up in my merged Word document. Price Part $23.00 A100S $23.00 A100S $2.25 A3A07S $2.25 A3A07S $3.58 A314BLKS I believe it would be done with some sort of nested command but I am not sure how to set it up. Any advice? |
#2
|
|||
|
|||
You (or somebody else) has certainly made it difficult by arranging the data
in that way. It would be more normal to arrange it Part No. Official Price Customer Price Then it would be a simple matter to compare the entries in the Official Price and the Customer Price fields. Before trying to advise you how to do it with the data as you have it (which will not be simple), is it possible to re-arrange the data as shown above? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Denise H. via OfficeKB.com" wrote in message ... I have an Excel spreadsheet which contains the part numbers and prices from our official price list and from orders received from customers. I need to determine if the customer has used the correct price on their order. The spreadsheet has 2 columns, price & part. I'd like to set up my merge such that if the part & price match the next record, those records are skipped. For example, in the spreadsheet below, only the last item would show up in my merged Word document. Price Part $23.00 A100S $23.00 A100S $2.25 A3A07S $2.25 A3A07S $3.58 A314BLKS I believe it would be done with some sort of nested command but I am not sure how to set it up. Any advice? |
#3
|
|||
|
|||
Thanks for the reply. I'm not certain that I am doing this as efficiently
as possible. Perhaps it could be better acomplished in Excel, except that I am more familiar with queries/filtering in Word. The official price sheet is a fancy spreadsheet which contains pictures of the models, and other data necessary for the sales team. I created a simpler chart of just the parts and prices and then download the weekly order data from our online database. Because all of the parts on the official price list are not ordered every week, I am not able to simply copy the official prices and paste them to the spreadsheet of orders. -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
Sounds more like something for which Access should be used.
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Denise H. via OfficeKB.com" wrote in message ... Thanks for the reply. I'm not certain that I am doing this as efficiently as possible. Perhaps it could be better acomplished in Excel, except that I am more familiar with queries/filtering in Word. The official price sheet is a fancy spreadsheet which contains pictures of the models, and other data necessary for the sales team. I created a simpler chart of just the parts and prices and then download the weekly order data from our online database. Because all of the parts on the official price list are not ordered every week, I am not able to simply copy the official prices and paste them to the spreadsheet of orders. -- Message posted via http://www.officekb.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Mail merge problem when filtering data from Excel data source | Dave F | General Discussions | 5 | December 3rd, 2004 06:45 PM |
Mail merge error occurs when filtering Excel data source | Dave | Mailmerge | 1 | December 2nd, 2004 10:46 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |