Software

Ask something
Question Locked

excel vba macros

0 helpful
2 replies

by mlarsen1982

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
hello, I am wondering what the best/easiest way to do this is. I have 2 worksheets from a workbook called Annual Budget that I want to copy essentially. I grouped graphs from multiple spreadsheets into one tab, and want these other 2 worksheets from Annual Budget to be 2 other separate tabs to create a new workbook. I tried to do a 'move or copy worksheet' but the information didn't automatically update on the new sheet after it was entered on the original. Do only graphs do this then? This new workbook I am creating is for reporting purposes only, to gather the info the managers need more efficiently for meetings. Basically I want the exact same page, but I just want it displayed on another workbook too. Any way for this to happen? thanks very much

2 replies

by sgt_shultz

sounds like you made need to add a worksheet reference to your macros. see Help in Excel for how to do this or paste your macro so we can suggest.
Or before you open Excel, copy your original Annual Budget to another file, say 'copy of annual budget'. open that one and edit out the stuff you don't want. does that make the formulae work?

This discussion is closed to new replies.