I need to sum a specific column in several sheets with VBA. The column has the same name, but a different location in each sheet. Also, the number of rows in the column is dinamic. I've been working on it for a few hours now, but i cant seem to get it.
I know i have to write excel to check sheets i to 8, and that the code to write the sum at the end of the column should look something like this: LastRow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row + 1.
PLEASE help me!