Hello VBA gurus!
I am pretty new to VBA and I am in need of help with a code in VBA that I want to be executed on all sheets in the workbook except the sheet called "Total". I further want the results from each sheet to be "printed" in the "Total" sheet. Right now, the code is only running on the active sheet, as well as it is printing the same value into all of the cells in the "Total" sheet. The different sheets have different amounts of values, and I want to use the code in several workbooks, and therefore I do not know the name of all the sheets except the "Total" sheet.
I would appreciate any help to make my code run properly, thank you in advance!
The code so far looks like this:
![]()
Please Login or Register to view this content.
Bookmarks