UpDate Formula

[billykiller05]

I currently have some code written to copy and sheet and rename the new sheet to whatever the user enters in on UserForm2 TextBox1. I now need a way to update a total formula when a sheet is added like the formula below to include whatever name is used.

B27+F27+J27+"whatever name the new sheet is"!B27+"whatever name the new sheet is"!F27+"whatever name the new sheet is"!J27 and so on.

[Richard Buttrey]

Hi,

Try adapting the following.

Please Login or Register  to view this content.

just add other instances of the INDIRECT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)&"!B27"
bit, changing the B27 as necessary

HTH