Posts by sobi_256

thank you so much to both of you and answering my queries

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

Hello Guys

i have a following line

how can i change this to worsksheet function kind of thing which will not show the formula and only show the desired answers

Regards

thank you so much

hmm but i want in to be dynamic , so is the below code the right syntax

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

O2 is dynamic as well like it can be any column which will be 1col+5 i was gonna use a loop thats why i wanted o2 to be dynamic

so this o2 should be cells(i,1Col+5), i hope i am making it clear

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

ORDERS.xlsx

Regards

Thanks

for example 1 shirt is made up of 3 individual components
components qty

25 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 qty

LACE BLACK 5

LACE WHITE 6

so if i order 5 shoes the out put sheet should have
components qty

LACE BLACK 25

LACE WHITE 30



i hope i am explaning itself clearly

thank you for reply royUK

I am open to changes , the database now has no empty rows, the output sheet has the information which is related to orders, if in order sheet a product quantity is 30, in utput sheet the items is multipied by 30, output sheet also contains other relevant information

DB.xlsx