Multiply with cell value for each matching sheetname in a list

Hi,

I have a dynamic list of worksheet names in range AC15:AC115 in sheet "Kalkyl".
In range AA15:AA115 in the same sheet, the user can input a number value.

I want the user to be able to multiply the specific value they input in AA15:AA115 with range B8 to the lastrow in each corresponding sheet.

So for instance, AA17 = 8. Multiply each value in B8 to the lastrow with 8 in the sheetname matching the value in AC17.

Is this possible?

Originally Posted by Kaper

Sounds like a good task for event handler of worksheet_change event

In the sheet code in

Please Login or Register  to view this content.

one shall check if Target is in AA column and then use target.offset(0,-1) (or each cell in target offseted laet as name of sheet where this simple myltiplying will occur

You are right, this would be great with event handler. The problem is I have no Idea how to match a cell value with a worksheet name.
Could someone help me with the code?

Originally Posted by Kaper

dummy version could be

Please Login or Register  to view this content.

Works great! Thanks!

Originally Posted by Kaper

dummy version could be

Please Login or Register  to view this content.

I would like to use this as a normal sub routine instead, how can I adjust the code?