LinkBack URL
About LinkBacks
I have a list of names on one tab and all those names have there own tab to keep employee information. Is there a way to make a new tab to gather all the names and a specific cell from each tab?
I have a list of names on one tab and all those names have there own tab to keep employee information. Is there a way to make a new tab to gather all the names and a specific cell from each tab?
Welcome to the forum.
There is no 2108 version - that’s a release number. Your version is MS365.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I just added my attachment.
I'm trying to setup a quick spreadsheet to track and supply payroll information.
Any help is appreciated.
Please update your profile.
Profile is updated
I would like to have a tab that looks through all tabs and tells me what an employee was paid on a specific date
Perhaps the following will help.
1. Put the date to be referenced in a cell (D1 in the attached file)
2. Find the amount paid using: =INDEX(INDIRECT("'"&A2&"'!X12:X21"),MATCH(D$1,INDIRECT("'"&A2&"'!v12:v21"),0))
Let us know if you have any questios.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks