If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!!! |
#2
|
|||
|
|||
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!!! |
Thread Tools | |
Display Modes | |
|
|