I need my template to show more than one months results

B

breezy

Hi! I would like to give a big thank you to Max for all the direction he has
given me in the discussion world!!! I'm a real rookie!

I have a template that exports results from one sheet to another based on
what is entered. It currently only returns results for a specific month and
need it to return results for several months, upto the previous year or
current year.

The following is what I currently have in my results sheet.

Inputs in A1:A3
In C2
=IF(COUNTA($A$1:$A$3)<3,"",IF(AND(Sheet1!A4=$A$1,Sheet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!A:A,SMALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)>COUNT($C:$C),"",INDEX(Sheet1!S:S,SMALL($C:$C,ROWS($1:1))+2))
Select C2:M2, copy down to cover max expected extent of source data in
Sheet1. Format cols to taste. All lines satisfying the criteria inputs in
A1:A3 will appear neatly packed at the top. Try changing the criteria inputs
to a different set, it'll return accordingly.

Thanks so much in advance for any advice you can offer!!!
Breezy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top