Hi! I need a little help. Basically, what I'm trying to do is to paste the values of certain cells from other worksheets if certain conditions are met. I think I'm supposed to use the index or match worksheet functions but i'm getting really confused. Can anybody paste sample codes or stuff like that? Help will be much appreciated. Thanks!
Hi Edelweiss,
It would be better if you could upload your sample workbook.. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Here you go. What I'm basically trying to do is to fill up the "Results" Worksheet, using data from other sheets, say "May 2012". Thank you very much!
By the way, the content of cell B3 for example in "Results" (for the Daily sales) should be the sum of all the sales of the certain dishname for that day. :3
Hi Edelweiss,
See the attachment...results sheet, B column where I have used the below formula to obtain the required results :-
=SUMPRODUCT(('May 2012'!$A$6:$A$37=Results!B$2)*('May 2012'!$B$6:$C$37="sales")*(OFFSET('May 2012'!C$6:C$37,0,A3)))
You can customize this further as per your usage. Thanks.
Sub2.xlsm
Regards,
DILIPandey
<click on below 'star' if this helps>
Thank you!
You are welcome. . . .
cheers
Regards,
DILIPandey
<click on below star if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks