Everyday I have to prepare Rate Column in TopSheet from DataSheet. Rate Column is the Breakup or Details of Total Value. How can I have this column from DataSheet using formula or by any other shortcut way instead of typing manually? Can anyone suggest? Thanks.
Last edited by sumonrezadu; 08-28-2009 at 10:13 AM.
Fix your column A entries so they match the other sheet and you can use a simple SUMIF() formula to get the answers:
=SUMIF(DataSheet!B:B,A2,DataSheet!C:C)
Last edited by JBeaucaire; 08-26-2009 at 07:27 PM. Reason: Sheet removed...see below for latest version
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for your reply. Actually my goal is not to get the result (Total Amount of Rate). I need exactly the same rate column on my sheet. That is which shows in my attachment i.e 3600*2+3700*1. My manager wants this break-ups beside the total amount. So can I get 3600*2+3700*1 writings from DataSheet in Rate Column without typing it? Thanks again for your reply.
I can't fathom how that would work, but how about this. Same information just in a more "Excel" format.
Ok, I have almost solved my problem. Pls see the attachment where I get "Movement Area' & "Amount" column from DataSheet. Anything I change in DataSheet my TopSheet updates automatically because of formula. My Accounts Manager only approves my printed TopSheet copy (hard copy), he doesn't work with my soft copy, he wants to see the detail of my amount. Now I'm preparing Pivot Table and using the function I'm getting the desired value, after that I copy my value and pasting special value to my top sheet in "Amount Detail" column. Now I can't understand why my rate1() function (my macro) doesn't work properly. While I'm dragging M5 cell in Sheet2 down to M14 cell it gives the wrong result. Even when I change value in Sheet1 and refresh data of pivot table in Sheet2, my function rate1() isn't updated. But my problem is solving (getting the correct result) when I'm going Edit Mode (pressing function key F2) in active Cell M5 or M6 or M7..so on and pressing Enter each time.
Have you any suggestion?
Last edited by sumonrezadu; 08-27-2009 at 11:53 PM. Reason: for attachment
yesOriginally Posted by JBeaucaire
thanks for the answer. i have done with this
website maintain
Thanks all. My problem solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks