I have a master sheet that has our employee information and start dates where I have broken up their start dates into different columns for their 5, 10, 15, 25 etc to 40 anniversaries. I'm wondering if it's possible to somehow take the information from the master sheet and auto-populate the information in the the new sheets ( 5 Years, 10 Years, etc) and have the information sort by the correct year without having to do it manually for each sheet?
Thanks in advance! I know nothing.
Related:
Master sheet auto-populating anniversary dates into new sheets?
Could you supply us with a sample of your work book please just with dummy data. We'd like to see how you have set up your Master sheet and the individual sheets (just two or three of the individual sheets should do).
You can upload a sample of your work book to a free file sharing site such as DropBox, ge.tt or Sendspace and then post the link to your file back here.
We should then be able to better understand your query and help you solve it.
