A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

My Worksheet Needs to Input Cell Data Automatically to Other Cells



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2009, 11:31 PM posted to microsoft.public.excel.worksheet.functions
Breezy
external usenet poster
 
Posts: 38
Default 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  
Old April 14th, 2009, 02:17 AM posted to microsoft.public.excel.worksheet.functions
Sheeloo[_5_]
external usenet poster
 
Posts: 239
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.