Previous Topic Next Topic

Master sheet auto-populating anniversary dates into new sheets?

Closed
ImmaUnicorn
Posts
1
Registration date
Thursday March 2, 2017
Status
Member
Last seen
March 2, 2017
 - Updated by ImmaUnicorn on 2/03/17 at 05:24 PM
vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
 - Mar 3, 2017 at 04:03 AM
Hello,

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.

1 reply

Answer 1 / 1
vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
 249
Mar 3, 2017 at 04:03 AM
Hello ImmaUnicorn,

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.

Cheerio,
vcoolio.
0