I would like to select a month from a drop down list and have the field below it populate from corresponding sheets. I have an attached spreadsheet to further explain.dummy.xls
I would like to select a month from a drop down list and have the field below it populate from corresponding sheets. I have an attached spreadsheet to further explain.dummy.xls
Hi her.rockstar,
You can use below formula:-
Formula:Please Login or Register to view this content.
see attached:- dummy.xls
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hey, I'm not sure that's what I'm looking for., thank you of course, but I'll try to explain again.
If I choose Jan in B1 (Sheet1), then B2 should read 12, B3 should also read 12 because there are that many Ys on both sheets (coincidentally).
Okay.. try using below formula:-
Formula:Please Login or Register to view this content.
See attached:- dummy(1).xls
Regards,
DILIPandey
<click on below * if this helps>
Perfect!
Thanks so much for your help!
you are welcome rockstar. ... cheers
Regards,
DILIPandey
<click on below * if this helps>
Ohhh, okay, I've gone and confused myself.
Try to understand I use a dummy sheet to protect some sensitive information.
Sheet1, 2, 3, etc are placeholders for sheets with names that contain spaces, and it's throwing me off big time, with the quotations. Would you mind taking a look at a revised spreadsheet for me with the sheet names changed? Thanks so much.
dummy2.xls
Hi rockstar,
Just corrected the references of sheet name in the formula:-
see attached:- dummy2.xls
Regards,
DILIPandey
<click on below * if this helps>
Can you tell me what '!A4 refers to......INDIRECT("'"&A2&"'!A4")...... as I transpose this formula to my actual data sheet, I'm not sure what to it is referencing. A4 appears to be an empty cell?
HI rockstar,
That refers to the cell A4.
And offset function moves it to 1 right and zero down.. so just one column right which is the month column (jan) as per filter. Hope this helps. thanks.
Regards,
DILIPandey
<click on below * if this helps>
Hi again, so in my actual document, the months are unfortunately located in a different spot. Jan is actually in C2 on the Tony Day to Day sheet. The problem then, is that I have to adjust it. Would I change the A4 instead to B3? (I've tried it and it doesn't work), or do I change it to A3, and then increase the offset by 1 somehow?
Hi rockstar,
I would suggest you to first see the Excel help and learn offset function, then you can easily fix that.
Also see the data arrangement, where its working and then you can easily figure out what reference to be changed to suit, your data set. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
You have solved my dilemma. Thanks so much again for your patience and expertise.
Adam
hey.. you are welcome Adam.. cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks