I am working on a spreadsheet and need some help. Is there any formula or
macro that can take into account a new sheet being added on a monthly basis?
In short I need a worksheet that will link to the new worksheet on a monthly
basis without a lot of work. Everything is in the same workbook. Any help
would be greatly appreciated.

Thanks,

We would be glad to help Chris, and yes, worksheets can be linked. But in
order to offer any specific help, we would need a much better description of
what you have, and what you're trying to do........but please no NOT attach a
file to your post....just describe it in words.

Vaya con Dios,
Chuck, CABGx3

"Chris" wrote:

I am working on a spreadsheet and need some help. Is there any formula or
macro that can take into account a new sheet being added on a monthly basis?
In short I need a worksheet that will link to the new worksheet on a monthly
basis without a lot of work. Everything is in the same workbook. Any help
would be greatly appreciated.

Thanks,

More explanation and examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris" wrote in message
...
I am working on a spreadsheet and need some help. Is there any formula or
macro that can take into account a new sheet being added on a monthly
basis?
In short I need a worksheet that will link to the new worksheet on a
monthly
basis without a lot of work. Everything is in the same workbook. Any
help
would be greatly appreciated.

Thanks,

Let me give a little background and then move forward from there. I'm in
accounting and this particular workbook (Bank draw) that I am using gets
printed out and forwarded to the bank on a monthly basis. I add a new
worksheet every month to summarize what we spent versus the budget. I have
one worksheet that has the detail for the costs that apply to the bank draw
and I have a worksheet that applies to costs outside of the bank draw. I use
a third sheet to summarize the two costs in a side by side comparison and
give the total. The budget which changes on a monthly basis is on the front
sheet that I update on a monthly basis (add a new worksheet) and forward that
one to the bank. I could put the budget on the detail sheet and have it flow
forward to the summary page on the front (The one I update monthly), but my
boss won't go for that and the other accountants will hate me for changing
things on them. So what I am looking for is a formula or macro that can
recognize a new worksheet being added and pull the information from that. I
hope this made sense. Thanks for your help.

"CLR" wrote:

We would be glad to help Chris, and yes, worksheets can be linked. But in
order to offer any specific help, we would need a much better description of
what you have, and what you're trying to do........but please no NOT attach a
file to your post....just describe it in words.

Vaya con Dios,
Chuck, CABGx3

"Chris" wrote:

I am working on a spreadsheet and need some help. Is there any formula or
macro that can take into account a new sheet being added on a monthly basis?
In short I need a worksheet that will link to the new worksheet on a monthly
basis without a lot of work. Everything is in the same workbook. Any help
would be greatly appreciated.

Thanks,

Well, it kinda/sorta all goes over my head Chris. It would help me, and
maybe others, if you would give us the name of your workbook, and the names
of all the sheets therein before you start your monthly update. Then the
names of any sheets that have changed by your update and if their names have
changed/added new ones/deleted any, etc. Then, between which sheets does
the linking occur, and which sheetnames get printed to send out?

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Let me give a little background and then move forward from there. I'm in
accounting and this particular workbook (Bank draw) that I am using gets
printed out and forwarded to the bank on a monthly basis. I add a new
worksheet every month to summarize what we spent versus the budget. I have
one worksheet that has the detail for the costs that apply to the bank draw
and I have a worksheet that applies to costs outside of the bank draw. I use
a third sheet to summarize the two costs in a side by side comparison and
give the total. The budget which changes on a monthly basis is on the front
sheet that I update on a monthly basis (add a new worksheet) and forward that
one to the bank. I could put the budget on the detail sheet and have it flow
forward to the summary page on the front (The one I update monthly), but my
boss won't go for that and the other accountants will hate me for changing
things on them. So what I am looking for is a formula or macro that can
recognize a new worksheet being added and pull the information from that. I
hope this made sense. Thanks for your help.

"CLR" wrote:

We would be glad to help Chris, and yes, worksheets can be linked. But in
order to offer any specific help, we would need a much better description of
what you have, and what you're trying to do........but please no NOT attach a
file to your post....just describe it in words.

Vaya con Dios,
Chuck, CABGx3

"Chris" wrote:

I am working on a spreadsheet and need some help. Is there any formula or
macro that can take into account a new sheet being added on a monthly basis?
In short I need a worksheet that will link to the new worksheet on a monthly
basis without a lot of work. Everything is in the same workbook. Any help
would be greatly appreciated.

Thanks,