Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-12-2012, 07:31 AM
daymaker daymaker is offline Adding records to a custom sorted spreadsheet Windows XP Adding records to a custom sorted spreadsheet Office 2000
Novice
Adding records to a custom sorted spreadsheet
 
Join Date: Feb 2012
Posts: 22
daymaker is on a distinguished road
Default Adding records to a custom sorted spreadsheet

I have a spreadsheet that has been presorted by another application. In the current spreadsheet state, it only lists one order per customer. For many customers, we have more than one order during the year which are in a separate spreadsheet. We are wanting to add in the other orders per customer without disturbing the current sort order as it is required for proper distribution of a letter to each customer. We will then be able to draft an order summary list for each customer from the full order list & print them in the presorted order.



So I was thinking about assigning a key field to the current customer list in its sort order and then copying the entire customer/order list into a second worksheet and then comparing the two worksheets via a column in this second worksheet & add the same key per customer. I would then sort this second worksheet by this key, which would result in all records per customer being in the same order as the current spreadsheet.

Here are sample sheet images to illustrate -

Spreadsheet that has no multiple orders per customer; in the sort that needs to stay in:




Spreadsheet that has multiple orders per customer; in basic alphanumeric order by 'company':



As you can see, all company names listed on first sheet are present on second at least once while several have multiple orders per company.

Maybe there is a better way than my general logic. I'm looking for formulas/macros to get this sort of thing accomplished.

Thanks for any help!

John
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding records to a custom sorted spreadsheet Groups to be sorted by start date in MS Project Antares Project 3 12-09-2011 03:17 PM
Adding records to a custom sorted spreadsheet Need advice on category sorted e-mail merge GeoB Mail Merge 3 09-08-2011 11:03 PM
Adding comma to a custom type. mcook Excel 1 08-13-2011 03:08 AM
Adding records to a custom sorted spreadsheet Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
Adding records to a custom sorted spreadsheet Merge Doc skips records eonelson Excel 11 01-30-2011 03:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft