Same problem, Different day!

[rdrum]

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]

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]

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.