This is my first post. I'm quite proficient with Excel but have never learnt Visual Basic.
I have a workbook with two sheets. One contains a number of items of data, the other some totals. The data sheet contains a column that has a yes or no option.
The totals sheet totals data by month. I want the sheet to record on the 1st of each month the total number of No's in column mentioned.
I have a formula =if(today()=date(year(B1),month(B1),1)countif(sheet3!F:F,"No"))
This works but only on the 1st of each month and previous months data obviously disappears.
Is there a way to do what I want with a formula or do I need a macro that runs on 1st of each month which contains similar cose to my countif formula?
If a macro is needed, can anyone give me a hand? As I said I don't know VBA.