Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a master expenses file that has a page for each employee summarising their expenses. The employee sheets run off a hidden data sheets.

I want to send each employee a copy of their expenses with the lookups etc hidden but still in tact so that they can complete the coding etc using lookup lists like project and expense codes from the data sheets.

What I envisage is a macro create to a set of individual employee files with only their page but with the lookups and data in each remaining in tact and hidden. I've been trying to create a macro to systematically work through the file creating new files for each employee deleting each of the other employee sheets but retaining the hidden data and related lookups - with no success

Any help appreciated.

share|improve this question
    
Would having the data sheet exist on a different file in a different network location be a solution? –  Dave Rook Aug 21 '13 at 8:18
    
I don't think so, I need the employees to use the lookups etc offline –  Phil S Aug 21 '13 at 8:35
    
Maybe a completely different approach is to disable all tabs but one. You distribute the whole Excel file, but they can only see/edit one page. Don't know how to do that though. –  Jan Doggen Aug 21 '13 at 8:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.