+ Reply to Thread
Results 1 to 1 of 1

Referencing work schedule data in another file

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Referencing work schedule data in another file

    Hi guys,

    So it is a little bit difficult for me to explain this problem but i am still going to try, and i hope someone will understand

    In short i want to make a file (working hour schedule), that will be linked with a original schedule file sent by my company. My new file should be able to pull out automaticaly new data every week when i receive new schedule.

    The file that i receive is protected, it has around 15 worksheets, which includes amonf the rest INDIVIDUAL SCHEDULE and 7 sheets of SCHEDULE DAY 1 up to 7. From what i understand that file is written in vba and i dont have an access to the code.

    So SCH DAY 1 for example, it consist of 50 schedule names on the left side (cashier1, cashier2, security1 etc...) and timings on top 00-24. Timings are divided by 15minz so if u work 7am to 10am it looks like this: SSSSSSSSSSSS. On IND SCH for that person it shows "security 7am-10am" (S stands for security, there is another sheet with different values like S, B for break, C for cashier).

    So i want to know how can i pull that data SSSSSSSSSSS in to a new file with no vba and that it can read this value as: "security 7am-10am".

    Thanks for reading and i hope i managed to explain it correctly.

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 03-08-2018 at 04:19 PM. Reason: Title

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1