Results 1 to 3 of 3

Thread: Look up formula or help

  1. #1

    Look up formula or help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Looking for a bit of help with my shift rota spreadsheet. On the Schedule part of the sheet I choose the names of people doing the shifts and there hours are auto calculated on employee hours page.

    However what im looking to do is have an auto look up on Shifts by name page where it looks to the schedule and pulls over the data to the corresponding name, ie shift and time.

    I have attached the spreadsheet to this thread any help is appreciated.

    Thanks in adavanceNEW DUTY SHEET 06052011 (Autosaved).xls

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,087
    Articles
    79
    Blog Entries
    14
    Hi there,

    Welcome to the forum, and sorry it took so long to get an answer back to you. I was ridiculously busy this past weekend.

    I've filled in some formulas for you, but I'll warn you that th formula to pull back the hours is fragile. Your data sheet is in a difficult format to work with. With multiple rows for some areas and not others, it takes some work to make sure the right data is coming back.

    At any rate, this sure work for you.

    HTH,
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    I agree Ken, whilst you have provided a solution i really think that the workbook layout and structure should be reworked, it's likely to become unmanageable in it's present form.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Posting Permissions

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