Hello everyone
I have three tables in three sheets and I would like to put this formula after the table directly at the last column of it
My issue is how put the string "Total" in the columns AD to AG and in AH put the formula according to the table namePlease Login or Register to view this content.
Untitled.png
I tried something like that but got an error
.Range("AH" & p + 1).Formula = "=SUBTOTAL(109," & .ListObjects(1).Name & "[Total])"
I have posted at this link too
http://www.eileenslounge.com/viewtopic.php?f=30&t=31606
Regards
Bookmarks