how can I create a running list?

bsack · May 23rd, 2002, 07:32 PM

Thanks for perusing my perplexity. I am creating a database to keep track of items we wish to return to vendors. Each workbook represents a vendor and in the first worksheet I have functions which total the dollar amounts for each category of merchandise. Here is a representative cell:
=SUM('START HERE:THE END'!C39)
In this way all the intervening sheets (between 'start here' and 'the end') are automatically totalled on the fly. What I wish to do, however, is automatically keep a running list of all the claims (i.e. intervening worksheets) on the first worksheet in the workbook, and have that contain the claim#, date, and amount of each individual claim (worksheet). I've thought of using a macro to simply paste the information into a list when the new worksheet is created, but when the sheet is moved to another workbook I don't want it to be listed anymore and I haven't figured out how to overcome that cleanly...Any assistance is sincerely appreciated.

Jay Petrulis · May 23rd, 2002, 08:40 PM

Hi,

Please provide some sample data (including the columns used/headers, etc.) and some specific details of your request.

On your summary sheet, what do you want to see?

Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 07:32 PM	#1
bsack New Member Join Date: May 2002 Posts: 1	Thanks for perusing my perplexity. I am creating a database to keep track of items we wish to return to vendors. Each workbook represents a vendor and in the first worksheet I have functions which total the dollar amounts for each category of merchandise. Here is a representative cell: =SUM('START HERE:THE END'!C39) In this way all the intervening sheets (between 'start here' and 'the end') are automatically totalled on the fly. What I wish to do, however, is automatically keep a running list of all the claims (i.e. intervening worksheets) on the first worksheet in the workbook, and have that contain the claim#, date, and amount of each individual claim (worksheet). I've thought of using a macro to simply paste the information into a list when the new worksheet is created, but when the sheet is moved to another workbook I don't want it to be listed anymore and I haven't figured out how to overcome that cleanly...Any assistance is sincerely appreciated.

May 23rd, 2002, 08:40 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Please provide some sample data (including the columns used/headers, etc.) and some specific details of your request. On your summary sheet, what do you want to see? Jay