Changing template data
Hey everyone,
I was wondering if anyone could help me with this template as I have a project for work that I dug myself into and can't figure out how to get it to work.
- I need the totals on the side to total each category individually (Vacation, Unpaid, Paid, unauthorized, Other)
Any help would be greatly appreciated. Thank you.
I have added a mocked-up version of what I'm looking for. I need these changes made to each month.
Employee Absence Report (COPY).xlsx
Thank you.
Last edited by Jordon R; 04-25-2024 at 07:50 PM.
I don't see where you have manually mocked up anything that actually shows what you want.
Administrative Note:
Is your forum profile showing the Excel PRODUCT that you need this to work for? "Not sure" is not telling us anything.
Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.
The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.
Thanks.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you, I have added a mocked-up version. Sorry, I'm new to this forum. Still learning.
worksheet or tab name : January
Cell AI9 formula
Formula:
Please Login or Register to view this content.
Thank you! how do you get that formula so I can fill the rest of the columns? And do you know how to delete all the filters on row 8 except column B?
Is that what you mean? Using VBA CODE
Please Login or Register to view this content.
Last edited by wk9128; 04-24-2024 at 09:35 PM.
I'm going to be honest; I have no idea what that means. I'm really new to diving into this stuff.
HI Jordon R Please download the POST # 6 attachment and it has been prepared for you
You're Welcome. Glad to help . Thank You for the feedback and rep.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
Thank you so much for the help. Its greatly appreciated. Is there a way to remove the filters from row 8 except column A?
PLS press the buttonOriginally Posted by Jordon R
Unfortunately, my work computer is blocking the macro function due to a security risk being an outside sourced function. I apologize for all of the questions. I was also wondering if there's a away from the totals to accumulate through the date sheets. For example, If I input 3 vacation days in January and the counter reads 3, when I got to February the total would read 3. If I input another vacation day in February it will go up to 4, then march would read 4 and so on.
Administrative Note:
Is your forum profile showing the Excel PRODUCT that you need this to work for? "Not sure" needs to be updated without delay, please.
Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.
The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.
Thanks.
ANS. POST#11
First define a name, the name is xx , and the placement formula is =REPLACE(GET.DOCUMENT(1),1,FIND("]",GET.DOCUMENT(1)),)&T(NOW())
worksheet or Tab name : February
Cell AH9 formula Then copy this formula to next worksheet March and others
Formula:Please Login or Register to view this content.
Thank you!
You're Welcome. Glad to help . Thank You for the feedback.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks