Hi,
I'm creating a dashboard for work, and I'm going to have multiple worksheets that need to look identical with text and graph positioning and fonts etc. The look of the worksheets is likely to change multiple times over the next few months, and I also find it very difficult to position graphs (generated from different data) at the exact same position without VBA, so I need something that I can apply across all of them. I'm not at all opposed to using/learning VBA for this, but I'm hesitant to do that until I know I need to, since everything I've thought I'd need to use VBA for thus far has ended up being much simpler without it and I've burned time by trying to do something too sophisticated. I'm just starting to learn excel obviously, but I did a CS major so I'm guessing learning the VBA for this won't take too long.
My ideal is to simply be able to make changes on one worksheet which will include cell sizes, font sizes, graph sizes and positioning, and then do something quickly to apply all those changes to 4 more worksheets. I'm open to any suggestions and willing to learn for it, I suspect I've missed something obvious since this seems like a super simple concept but I haven't been able to find anything yet.
Thanks in advance
Bookmarks