Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Merge data in Excel
From:	"Lawrence R. Fisk" <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Tue, 21 Jan 2003 06:21:44 -0500
Content-Type:	text/plain
Parts/Attachments:	text/plain (22 lines)

On a regular basis I need to merge 2 lists of data in Excel 2000.    For
example, the first column could be Inventory part number, and the second
column could be Quantity.     If I have 2 separate lists (let's say from
different warehouses), and I want to combine them, I would append the second
list to the first, sort, and then manually SUM the duplicate entries.   I
don't want to use a pivot table or subtotals, because I want the final
result to be a simple, clean list that a light Excel user can work with.

Can anyone suggest a simple way for these lists to get combined, with rows
being added where necessary, duplicates eliminated,  and quantities being
added?

A VBA application might do the trick, but I'm not sure where to look.

Thanks for your suggestions.

Larry.

                Curious about the people moderating your
                   messages? Visit our staff web site:
                    http://freepctech.com/staff.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG