Please help me on this simple problem

F

fuhongl

Joined
Apr 24, 2006
Messages
3
Reaction score
0
Hello, I am a newer to this site. I am currently working on a simple problem.

In a workbook, the first sheet is the roll-up page, which adds up the corresponding 16 seperate sheet's number, for example:
the formula for B16 in roll -up page is:

=sum('sheet1'!B16+'sheet2'!B16+.......'Sheet16'!B16)

I want to creat a macro which can easily copy sheet 16 to produce a new sheet, name it New, and then change the formula in roll up page to :

=sum('sheet1'!B16+'sheet2'!B16+.......'Sheet16'!B16+'New'!B16)

I am stuck at the formula change line. Can anybody help me on this?

Thank you very much.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Command Button to Sum specific cells in a range 5
VLOOKUP - Possibility of using a negative Col_index_num? 2
Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF? 4
Help needed to write a "SUMIF" formula in VBA 1
Return the values in another sheet 3
If Then Statements HELP! 2
Format linked workbook cells (updated) 2
Linking a relative formula to another worksheet problem 2

Back
Top