SOLVED

Gather information from one tab to another for payroll.

%3CLINGO-SUB%20id%3D%22lingo-sub-3333610%22%20slang%3D%22en-US%22%3EGather%20information%20from%20one%20tab%20to%20another%20for%20payroll.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3333610%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20using%20Google%20Sheets%20and%20never%20had%20any%20issues.%20However%2C%20our%20school%20is%20transferring%20over%20to%20all%20things%20OneDrive%2C%20so%20I'm%20trying%20to%20set%20up%20a%20spreadsheet%20similar%20to%20one%20I%20had%20in%20Google%20Drive.%20The%20formula%20was%20copied%20from%20the%20Sheets%20I%20had%2C%20but%20it%20did%20not%20work%20with%20my%20current%20Microsoft%20Excel%20spreadsheet%20for%20whatever%20reason.%20Any%20help%20is%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wanted%20to%20gather%20how%20much%20the%20student%20and%20staff%20workers%20got%20paid%20in%20certain%20pay%20periods%20on%20a%20different%20tab%2C%20but%20the%20formula%20is%20not%20working%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20I%20had%20with%20Google%20Drive%20with%20the%20first%20tab%20(had%20to%20erase%20personal%20informations)%20with%20a%20long%20list%20of%20student%20and%20staff%20names%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Screen%20Shot%202022-05-06%20at%2010.41.56%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369845iFD443F509639933C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-06%20at%2010.41.56%20AM.png%22%20alt%3D%22Screen%20Shot%202022-05-06%20at%2010.41.56%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETab%202%20that%20is%20being%20used%20to%20reflect%20tab%201.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-05-06%20at%2010.40.10%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369844iE95CBC258ABB9C84%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-06%20at%2010.40.10%20AM.png%22%20alt%3D%22Screen%20Shot%202022-05-06%20at%2010.40.10%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20this%20is%20the%20Microsoft%20Excel.%20Although%20to%20be%20fair%2C%20I%20have%20changed%20up%20the%20style%20and%20fields%20a%20bit%2C%20but%20that%20should%20not%20impact%20the%20formula%20as%20much%20as%20I%20have%20edited%20it%20to%20reflect%20the%20new%20cells%2C%20but%20it%20still%20does%20not%20work.%20I%20tried%20inputting%20some%20hours%20to%20see%20if%20any%20changes%20would%20come%20up%20in%20the%20second%20tab%2C%20but%20nothing%20happens.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-05-06%20at%2010.44.21%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369846i7DCFA2319542FF0D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-06%20at%2010.44.21%20AM.png%22%20alt%3D%22Screen%20Shot%202022-05-06%20at%2010.44.21%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-05-06%20at%2010.44.07%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369847iA23AC8C89D55DAE1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-06%20at%2010.44.07%20AM.png%22%20alt%3D%22Screen%20Shot%202022-05-06%20at%2010.44.07%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20the%20formulas%20needs%20to%20be%20changed%20a%20bit.%20Thanks!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3333610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3333725%22%20slang%3D%22en-US%22%3ERe%3A%20Gather%20information%20from%20one%20tab%20to%20another%20for%20payroll.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3333725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1383046%22%20target%3D%22_blank%22%3E%40fayysaywhatt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pay%20period%20-%20Kopie.JPG%22%20style%3D%22width%3A%20626px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369851iFD07B654602297DE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22pay%20period%20-%20Kopie.JPG%22%20alt%3D%22pay%20period%20-%20Kopie.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20it%20work%20if%20you%20change%20%22%20B2%20%22%20to%20%22%20A2%20%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3333781%22%20slang%3D%22en-US%22%3ERe%3A%20Gather%20information%20from%20one%20tab%20to%20another%20for%20payroll.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3333781%22%20slang%3D%22en-US%22%3EWow!%20I%20can't%20believe%20I%20overlooked%20that...%20(facepalms).%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20so%20much!%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

 

I have been using Google Sheets and never had any issues. However, our school is transferring over to all things OneDrive, so I'm trying to set up a spreadsheet similar to one I had in Google Drive. The formula was copied from the Sheets I had, but it did not work with my current Microsoft Excel spreadsheet for whatever reason. Any help is appreciated.

 

I wanted to gather how much the student and staff workers got paid in certain pay periods on a different tab, but the formula is not working for me.

 

Here is what I had with Google Drive with the first tab (had to erase personal informations) with a long list of student and staff names:
Screen Shot 2022-05-06 at 10.41.56 AM.png

 

 

 

 

 

 

 

 

Tab 2 that is being used to reflect tab 1.Screen Shot 2022-05-06 at 10.40.10 AM.png

 

And this is the Microsoft Excel. Although to be fair, I have changed up the style and fields a bit, but that should not impact the formula as much as I have edited it to reflect the new cells, but it still does not work. I tried inputting some hours to see if any changes would come up in the second tab, but nothing happens.

Screen Shot 2022-05-06 at 10.44.21 AM.png

Screen Shot 2022-05-06 at 10.44.07 AM.png

Please let me know if the formulas needs to be changed a bit. Thanks!

2 Replies
best response confirmed by fayysaywhatt (New Contributor)
Solution

@fayysaywhatt 

pay period - Kopie.JPG

 

Does it work if you change " B2 " to " A2 "?

 

Wow! I can't believe I overlooked that... (facepalms).

Thank you so much!