thank you so much to both of you and answering my queries
Posts by sobi_256


thank you for the reply, just for uderstanding, why the formula works if i use<> , the only difference between the two formulas is that <> is missing

Hello
i basically want to sum A,G, and D S from column A, my sum range is in column G, sorry my formulas are wong in the test file. but i still getting the same issue
i did use the below formula in cell k1 and this works, but the above formula does not. i will reupload the file again with the correction in formulas. I just wanna know where i am going wrong because if above formula is wrong then the below one shouldn't work as well

Hello Guys
Can someone pls explain why the formula works in k1 but not in k2, if anyone has the answer or a different formula pls lemme know
Regards
sobi

thankyou all , really appreciate the help

thankyou i think i have got it, i used from your previous code

this gives an error #VALUE! :(, do evaluate work over a range?

i just cannot figure out the syntax to use evaluate


thank you so much


thank you so much, really appreciate it, one more thing if i do not need formula to be show, like an evanluate of something how would i do that, like it still calculates the value but instead of showing a formula in cell it should show the answer


Hello Guys
i am stuck with the syntax of the formula
this works fine
but i want the above formula to be dynamic and i do not know what the proper syntax will be, i want A:J to be replaced to A:1Col and match (O2) to be replaced with match(cells(i,1Col+5))
Thankyou guys

thank you everyone, appresiate the help

just out of curiosity if the data is big, how would u do it then
thanks 
thank you so much, i was making it too complex by using auto filters and then copy pasting

Hello Guys
i am attacking an excel sheet and i am looking for a vba solution.
On database sheet i have products and in each product different items are used.
On orders sheet i have the product name and quantity in column A and B respectively.
i am looking for a vba solution that can give me an output like shown in column J to S.
Column L has the total quantity which multiply the oder quanity with the quantity shown in database
Regards
Thanks

for example 1 shirt is made up of 3 individual components
components qty25 X 23 X 1220 7
100 X 85X 450 8
50 X 35 X 567 9
so if i order 10 shirts the the outcome will be
components qty
25 X 23 X 1220 70
100 X 85X 450 80
50 X 35 X 567 90
1 shoe is made up of 2 individual components
components qtyLACE BLACK 5
LACE WHITE 6
so if i order 5 shoes the out put sheet should have
components qtyLACE BLACK 25
LACE WHITE 30
i hope i am explaning itself clearly 