Auto-populate sheets based on criteria

[Chgardne]

Hi All,
I have a report that should auto-populate to separate tabs based on Month and if the case is “active”. I currently use INDEX, but it stops working when I enter new data into my main data tab (sheet1) or it does not capture it at all. New data is entered on my main data tab daily. Is there another method I can use that will not break down? I am at a loss trying to figure out how to get it to work again. Any input is appreciated. A sample is attached.

[AliGW]

Are you still using Excel 2007 or something newer?

[Pete_UK]

The formula in column A of the Sep sheet only goes down to row 15, and so it misses the record for Sep in the main sheet. Copy that formula down further (at least to A17), then it will pick up the record.

If you want another way of doing it which is a bit more robust, then I can put something together for you.

Hope this helps.

Pete

[Chgardne]

Pete_Uk, sorry for the delay in response. I realized that I did the same mistake in my actual report as I did in the sample piece that I provided. It is working perfectly. Thank you for seeing was I failed to. Thank you for the offer to put something together, but I think this fix will allow me to continue my report as is.

[Chgardne]

Hi Ali, I actually use the latest version of excel on my main PC. The laptop I was working on to throw together a test sample to upload must have an older version stored...