Christina Christina
New Member
- Joined
- Sep 1, 2021
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
Greetings to all, I need help.
How do I create a table with the sum of each sheet cell from sheet ("Ali") to sheet ("20") and devide by sheet ("outcome").Cell ("B2") value by using VBA?
For example in the function, the first cell will be =SUM('Ali:20'!E5/$B$2) , then second cell is SUM('Ali:20'!F5/$B$2) etc.
Please be note that the table size is flexible base on the input of sheet( "strategies input") cell D2.
Which mean if the cell D2 is 8 then the table will be 8*8, if the cell D2 is 20 then the table will be 20*20.
Thanks in advance.
How do I create a table with the sum of each sheet cell from sheet ("Ali") to sheet ("20") and devide by sheet ("outcome").Cell ("B2") value by using VBA?
For example in the function, the first cell will be =SUM('Ali:20'!E5/$B$2) , then second cell is SUM('Ali:20'!F5/$B$2) etc.
Please be note that the table size is flexible base on the input of sheet( "strategies input") cell D2.
Which mean if the cell D2 is 8 then the table will be 8*8, if the cell D2 is 20 then the table will be 20*20.
Thanks in advance.