indirect dynamic sheet

Hi I'm looking for help on this formula. Tried looking for resources everywhere with no success. Please see the attached. The goal is to calculate the YTD totals of all the months for each of the the respective employees (i.e. Bob, etc) and each category (i.e. Bonus, Salary, Gross, Tax) I am...

Hi all so i am trying to do something that i don't know if is possible I have created a table for training courses that can work like a calendar The course details ar within the red boxes and can be anywhere within the range - but always come as a block. on my team view sheet - The formula...

Hi, I have some code that sends emails based on a range of cells however I want to make the reference indirect as sometimes there will be 5 rows to send and others there will be 25 rows. The below code works fine I just need help on the row that says " For Each cell In ws.Range("A2:A2")", how do...

I have two workbooks: A & B In workbook A worksheet 1, cell A1 has a date. I input it as: mm/dd/yyyy, but it visually shows as: Month Year. Example: Inputting 04/01/2019 will visually show as: April 2019. In workbook B, I have multiple worksheets. Each sheet is labeled after a Month and Year...

I have about 20 sheets, each with about 400 shapes (rounded rectangles). These shape values (ex. "=A32", "=B12", "=E24") are referencing 8 columns and 50 rows in the sheet. These referenced cells are using INDIRECT to pull data from another sheet, which is using IFERROR(INDEX..., so there is...

Can anyone help please, I am trying to reference a value at A1 on a sheet in my current workbook called Tabnames from white book which contains the dynamic name of the extracted sheet names from the open white book. But i am struggling with the correct syntax as i keep getting an error when...

I would like to make it so the data on a separate sheet can be looked up,without having to manually outline the data each time. Normally the formula would look as follows, referring to tabulated data on sheet antistatic. Along the left is date&time values and across the top are unique labels...

Hello all I have a formula shown below - =(COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment Band],"High",ArtRawData[Know Progress Art 4 Y7 Assessment 4],"Above Expected Progress")+COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment...

Hey Friends, I've been looking and looking but cannot find answers to my question. I have a macro that gives a list of filenames within a folder. I then used data validation to put the file names in a list. What I now want is to be able to write a vlookup that spits out data based on what file...

Hello, I've looked for other reply regarding the use of this function. I tried many possible solutions but they don't work. I have a dynamic Sheet (named as previous month, i.e. March-2015) and I need to do a vlookup with the previous sheet (e.i. February-2015). I tried this function...