LinkBack URL
About LinkBacks
I have 200+ WB.
They are all the same, but with different names.
Is there a way I can change the formula in H5 from "=Sum(H1:H4)" to "=Sum(H100:H400)"
And H9 from "=Sum(H6:H8)" to "=Sum(H401:H600)"
I have 200+ WB.
They are all the same, but with different names.
Is there a way I can change the formula in H5 from "=Sum(H1:H4)" to "=Sum(H100:H400)"
And H9 from "=Sum(H6:H8)" to "=Sum(H401:H600)"
Record one macro to do just both these actions, save it and sue it on all workbooks
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks