Hello excel experts,
I have made a macro that creates multiple sheets from the data in the Sheet1 with unique records.
So, all copy pasting and different sheets have been created but I want a total at the below of each sheet. There is total at the end of sheet1(master sheet) but that won't flow by my simple macro. so, can you help with a macro that with insert a total/sum line at the last row of each sheet (the number of sheet changes everytime).
Please let me know if you need additional details. Thanks a lot in advance.
I have made a macro that creates multiple sheets from the data in the Sheet1 with unique records.
So, all copy pasting and different sheets have been created but I want a total at the below of each sheet. There is total at the end of sheet1(master sheet) but that won't flow by my simple macro. so, can you help with a macro that with insert a total/sum line at the last row of each sheet (the number of sheet changes everytime).
Please let me know if you need additional details. Thanks a lot in advance.