Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Link formula from different sheets, 50 times.

Hi all knowledgeable people. I have a workbook. It has 52 regular worksheets.(SheetX) I also have one whorksheet in the book that is a tax table(SheetT). I've found a VLOOKUP function to calculate a tax value in that sheet. I'm (unsuccessfully) trying to link a value from SheetT back to SheetX. I can manually enter the value to work the tax figure out, but this is open to error by user input. I want to try to automate it.

So, SheetX will have a value at cell N14. I need to link value that to SheetT.A5 .

At SheetT.B5 will be a tax value that I now want to link back to SheetX.N15 .

I can easily link this up for just the one sheet, but I have no idea how to do so for the other 51 worksheets, all at the same time.

ps. I'm also unsuccessful at simply linking the formula at SheetT.B5 directly into SheetX.N15 for some reason.

TIA.

Thanks,

Arthur.

Link formula from different sheets, 50 times.

Hi all knowledgeable people. I have a workbook. It has 52 regular worksheets.(SheetX) I also have one whorksheet in the book that is a tax table(SheetT). I've found a VLOOKUP function to calculate a tax value in that sheet. I'm (unsuccessfully) trying to link a value from SheetT back to SheetX. I can manually enter the value to work the tax figure out, but this is open to error by user input. I want to try to automate it.

So, SheetX will have a value at cell N14. I need to link value that to SheetT.A5 .

At SheetT.B5 will be a tax value that I now want to link back to SheetX.N15 .

I can easily link this up for just the one sheet, but I have no idea how to do so for the other 51 worksheets, all at the same time.

ps. I'm also unsuccessful at simply linking the formula at SheetT.B5 directly into SheetX.N15 for some reason.

TIA.

Thanks,TIA,

Arthur.