Hello All,
My company has recently implemented an attendance policy. I found the spreadsheet i'm using form this site. I updated the January tab and entered all the formulas I need to calculate each occurrence. Im currently having trouble correctly copying and pasting the formulas from January's tab to February-December tabs, I also having trouble with the EO and 1T showing up in the selected color on the chart. Your help will be greatly appreciated.
Thank You So Much!
Last edited by babygirlt189; 04-22-2017 at 08:03 PM.
Hi, welcome to the forum
I am not a big fan of structured table formula syntax, and this is just another example of why lol.
Try this instead, it should be copyable across sheets...
=COUNTIF($B5:$AF5,AG$4)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
- Copy and paste these cells to a new location by pressing the keys “CTRL + C” to copy and then “CTRL+V” to paste it.
- Select the new range containing the formulae and press Ctrl+H.
- In the Find what box, type the # sign.
- In the Replace with box, type the = sign (to change the text to formula).
- Click on Replace All and then click on Close.
- You will get a popup “All done. We made 22 replacements”.
- Click on Ok.
For more information see this link. I have just stumbled upon this recently when facing the same challenges.
https://www.exceltip.com/excel-text-...eferences.html
Good Luck
As to the conditional formatting of cell containing EO and 1T on the January sheet, apply the following new rules to the range =$B$5:$AM$17
For EO: =B5=KeyEarlyOut Fill Gold, (sort of) Font white
For 1T: =B5=Keycustom1T Fill Red, Font white
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you!
Thank you!
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks