I am an excel newbie, I've done pretty good for myself (thanks, templates and help page!) but I need one more step to complete my project and I can't seem to figure it out.
I am working on vacation and sicktime tables for my employer. They automatically calculate accrural, subtract when time taken is entered, etc. I have a workbook page for each employee. What I want to do is create a final page that has everybody's name and what their current status is.
I know how to paste special and link from other workbooks, which is how I plan to get the data I want linked to the last page. BUT some of the data I want to link is a 'moving target' per se. (ie The vacation or sick hours available changes each pay period because of accrural)
So what I think I want to do: On my final page of totals, I have a box where I enter which pay period it is (any number 1 to 26) then link that box to choose the match from the 'pay period' column on that individual's sheet, which then would return the corresponding value from that row from the 'vacation available' column to be displayed on the final page.
I've tried LOOKUP functions, INDEX functions, and I con't get them to work, I must be missing some step. I haven't tried match yet.
Any tips? Thank you!
Bookmarks