Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cell data to another worksheet cell automatically. | New Users to Excel | |||
Update Worksheet Name Base on Cell Input Automatically? | Excel Discussion (Misc queries) | |||
Filter data automatically by input | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions |