I have a spreadsheet with about 6 tabs all referencing to different customers. The problem i have is if data is changed in tab1 and i need to send this to the customer all other tabs (and other customers info) goes with it.
Is there a way of sending just the tab i require to the required customer?
Another option is a seperate sheet for each so is there a way of seperating the current tabs into sheets of there own?
No tabs data refers to another so no issue there.
Otherwise is there a macro that will only send the required tab, something where the cover sheet has a list of tabs to customers which can be highlighted and sent
Bookmarks