Same problem, Different day!

rdrum · Apr 14th, 2002, 09:50 PM

Daleyman tried to help with this, but I couldn`t get the info to him, I will try explaining again. Every day I drag a new sheet over for my production report. I would like all my number totals to go to my sub totals on the new sheet, but I can`t use a sheet # because it would change every day. I may need prozac over this! Thanks

Tom Urtis · Apr 14th, 2002, 11:46 PM

Your question is kind of vague.

Please explain what you mean by "drag a sheet over". Also, please go into a little detail about how many sheets and what ranges are involved, and basically what you are trying to accomplish by giving a few examples. It'll be easier to help if you can fill out your question with some info about how the workbook is set up.

rdrum · Apr 15th, 2002, 10:59 AM

Thanks for the answer Tom. Dalyman had answered me, seems his e-mail got lost in cyber-excel, so he is helping me, but I appreciate it.

Apr 14th, 2002, 11:46 PM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	Your question is kind of vague. Please explain what you mean by "drag a sheet over". Also, please go into a little detail about how many sheets and what ranges are involved, and basically what you are trying to accomplish by giving a few examples. It'll be easier to help if you can fill out your question with some info about how the workbook is set up. __________________ Tom Urtis Microsoft MVP - Excel

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

Apr 14th, 2002, 09:50 PM	#1
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	Daleyman tried to help with this, but I couldn`t get the info to him, I will try explaining again. Every day I drag a new sheet over for my production report. I would like all my number totals to go to my sub totals on the new sheet, but I can`t use a sheet # because it would change every day. I may need prozac over this! Thanks

Apr 15th, 2002, 10:59 AM	#3
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	Thanks for the answer Tom. Dalyman had answered me, seems his e-mail got lost in cyber-excel, so he is helping me, but I appreciate it.