My Worksheet Needs to Input Cell Data Automatically to Other Cells
 

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

I'm wondering if I'm asking the question wrong as this will be the third
time I've asked. The other two times I didn't receive any responses.

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,S heet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!A:A,SM ALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!S:S,SM ALL($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!!!

My Worksheet Needs to Input Cell Data Automatically to Other Cells
 

Hello Breezy,
You probably did not get a response because your post is complex and what
you want to do is not clear...
I went through and I think you are picking the rows from Sheet1 where Col
A,C and G match the values in A1-A3...

Now, what do you want to do? It is not clear from your post.

Do you want the same thing from multiple sheets? It will get very complex
very soon... think about a macro solution...

-Sheeloo

"Breezy" wrote:

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

I'm wondering if I'm asking the question wrong as this will be the third
time I've asked. The other two times I didn't receive any responses.

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,S heet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!A:A,SM ALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!S:S,SM ALL($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!!!