• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Excel lookup then fill in datas

Hi Experts,

Attached File , first i type  contract number at  CELL O20  in one of the sheet ---ma mb mc md ua ub uc ud, then will generate the results .

Samples available at ' Sheet ma'   and ' Sheet ua'     Cell O33: Q35   , O36 : O53.

In case of  Contract no.25729  ,more then six items  matched  , then  sum all  quantity  to fill in Cell   O43  & O53 .

Regards
Stanley
sa-ORIGINAL-.xlsm
0
candychan611
Asked:
candychan611
  • 4
  • 3
  • 2
1 Solution
 
KnutsonBMCommented:
i'm not seeing how the number of cartons is calculated.......??

Brandon
0
 
KnutsonBMCommented:
on sheet 'ma' i put this formula in Cell O36 and drug down:

=SUMIFS(¿¿_MPO_D[QTY],¿¿_MPO_D[PO_NO],ma!$O$20,¿¿_MPO_D[DESC],ma!Q36)

And put this formula in cell 43:

=SUM(O36:O41)&" DZ"

i think that gets you part way to where you want to go.....

now we just have to figure out how you want the cartons calculated....i think....

Brandon

0
 
KnutsonBMCommented:
the characters didnt come accross, see attached.....
Copy-of-sa-ORIGINAL-.xlsm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
candychan611Author Commented:
Hi,

The Cartons is according to SHEET MITEM, COLUMN  I.

Thx
0
 
candychan611Author Commented:
SHEET MITEM, COLUMN  I. IS  THE  TOTAL QUANTITY OF PER CARTON
0
 
Vadim RappCommented:
Stanley, we will be happy to help, but what is the question? what is the specific problem you need our help to resolve? something specific that does not work as expected?
0
 
candychan611Author Commented:
Hi, i want generate a  MACRO that will generate the result as  attached  file   (i've show in  RED )
0
 
Vadim RappCommented:
Experts usually are effective in collective brainstorming specific difficulty when you are working on a project; if you need someone to do a project for you from start to finish, even a small one, dedication becomes more important. You will achieve the best result by selecting an expert who appears competent in the given area, and seeing if he has button "hire me" in his profile.
0
 
candychan611Author Commented:
Sloved some of questions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now