Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Data Mess | Microsoft Word Help | |||
Filtering Data | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |