grant

Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days. What I need to do is copy data from 1 of...

I am trying to create a holiday calendar for my office that when the holiday is booked in the table (list) it highlights the days taken in the below calanders. I was pretty sure I could do this by index match until that didnt work that is, so now I am stuck. Has anyone got an idea of how I can...

Hello - I have several cell that contain dates in text format. I'm trying to extract the dates from those cells & return values as a date format, preferably (Jun-19) format. Below is an example: I'm using =MID(A1,FIND("/",A1)-2,5) to extract -6/18, and then =SUBSTITUTE(B1,"-","") to get rid of...

Hi All, I have two datasets which can vary in length: Employee (column A), and Funding Source (Column B) I would like to create a table (in columns F and G) which will generate all possible combinations of Column A and Column B. Ideally, this table would be sorted by column F, and then by Column...

Hi there, I have rows of data in a sheet (sheet is named "Grant") that I would like to move to a new sheet named "Archive" automatically, once "Yes" has been selected from the dropdown box in column AK (data starts at row 9) in the "Grant" sheet. I would also like it to delete the row in the...

Hi, how to write the formula for Countif with multiple criteria and duplicates counted once. I want the number of client seen by E name as a criteria funded by. if E name seen the client multiple times a day then it should consider as a one client count. I attached the sample table and answer...

This is probably overly-complicated so I am not sure there is a conditional formatting solution but, it's a worth a shot. We have to track staff hours for multiple grants and there cannot be any overlapping time. In an effort to eliminate paper and pencil and simplify the process, I am trying...

OK, I am working on an accounting sheet to keep track of grant-related expenses. On Sheet 1, I have: Expense | Grant Expense is the amount. Grant is the grant it is associated with and chosen from a drop down menu. So it might look like: A | B $500 | Grant 1 $20 | Grant 2 $732 | Grant 1 On...

I'll try and explain my issue and what I'm looking for as best I can. If I'm not clear, please let me know. I'm trying to figure out how to apply conditional formatting to almost "remove" the formatting if a certain condition applies. I have a conditional formats for: <tbody> Rule (applied...

Hello I would like to add three new blank columns to an Excel spreadsheet using VBA after every 7 columns and I would very much appreciate any help to do this. Thanks Grant