I'm trying to get a macro that updates 1 worksheet with information from another worksheet.
I've attached a sample spreadsheet. Basically this is for work. Supervisors (level 1) report to managers (level 2) who report to owner (level 3). Level 1 should only see their employee. Level 2 should see all the employees under them; that is, all the employees of the level 1 supervisors they're in charge of. Level 3 should see everyone.
How do I get level 2 and level 3 to automatically update with the information found in the sheets of level 1? I would like to maintain formatting throughout.
Be sure to include crosslinks:
http://www.excelforum.com/excel-gene...d-sorting.html
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I'm attempting a different strategy here, this is why I did not link this post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks