Yaron Yehezkel
New Member
- Joined
- Jul 11, 2020
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hey guys!
I have some problem with the sun function in the VBA, and for some reason i can't find the solution.
I have a data of employees and theirs monthly salary. At the end of each table, in each of the 5 specific sheets, is the "Montly Salary in DOLAR" column. I'm trying to figure out the VBA code to sum the "Montly Salary in DOLAR" column.
I need that the total amount of all employees monthly salary (the sum) will be placed under the column "Monthly Salary in DOLAR" and one cell after the last data line.
The problem is that in each sheet, where the "Monthly..." columns is, there are different number of rows and columns (because not all the employees worked all those 5 months).
Any help would be appreciated.
Thank you
I have some problem with the sun function in the VBA, and for some reason i can't find the solution.
I have a data of employees and theirs monthly salary. At the end of each table, in each of the 5 specific sheets, is the "Montly Salary in DOLAR" column. I'm trying to figure out the VBA code to sum the "Montly Salary in DOLAR" column.
I need that the total amount of all employees monthly salary (the sum) will be placed under the column "Monthly Salary in DOLAR" and one cell after the last data line.
The problem is that in each sheet, where the "Monthly..." columns is, there are different number of rows and columns (because not all the employees worked all those 5 months).
Any help would be appreciated.
Thank you