Recent content by Anbuselvam K

Thanks a ton Boss.

It is working like a magic boss. without knowing this simple trick I tried Calculate, Do Events, and pause one second to calculate before export. but nothing has resulted.

Sorry Boss, I forgot to update it in the initial post as I thought if the validation name changes then values also will get updated accordingly. Please see the attached sheet and exported pdf as well (Only 4 PDFs I attached for example) it is exported the same content for all the names in the...

Dear @Marc L it is working great! Only it has to refresh or calculate each list name changes and then export to pdf. Now it is exported pdf with the same data for all the names. After changing the validation list names, B3:L37 need to update the data according to the name selected. Please...

Dear Excel Genius The below code is exported as a pdf to the mentioned path with the specified range("B3:L37") and the name Q7.value as MMM-YYYY and O11.Value.pdf" here the challenge is O11 cell has the dropdown validation list. Example values are "AAAA BBBBBB","CCCCC DDDDD EEEEEE","FFFFF...

For D13, A13 OUT required 130 from IN. Till A12 sum of OUT is 780, So above 780 matched IN till B12 sum of 906, then 906-780=126*C12+4*C13 For D14, A14 OUT required 140 from IN. Till A13 sum of OUT is 910, So above 910 matched IN till B13 sum of 1053, then 1053-910=143. we take 140 only as we...

I am using Office 365 Excel For Mac. the excel formula is given by @Excel Wizard. I try to convert the same to VBA Code as my worksheet slows where I have 100 IN, Price, and OUT with 10,000 Rows. I need the same output with a faster VBA Code.

First OUT 10 minus from First IN 15 then remaining 5 in First IN Second OUT 20 takes the remaining 5 from first IN, then 15 from second IN 15 then the remaining 11 in Second IN likewise, each OUT Uses IN and is multiplied by the prices which are D Column Values. the below formula gives D...

@Marc L I have filled all the D column Values manually. I hope now it is explained well.

Dear Excel Genius In the attached excel sheet A1 to A26 OUT KG, B1 to B26 IN KG, C1 to C26 Price$. I need OUT KG Price in Column D. Manually I calculated 4 cell values. Also, F Column I mentioned those 4 rows OUT KG on where to occur an IN KG. After finding the IN KG cells, multiply them with...

RM Purchase sheet having the purchase of the raw materials (Date wise Price & Qty) Temporary and Permanent sheets are having the formulations of products (Test) with % of raw materials. Production Sheet, Table Production, Production KG in Column "G", Column U to DP % of raw materials uses in...

Dear @p45cal Thanks a lot for your valuable reply. I have added Price first then Qty to achieve the formula to drag across the right side. But entering the purchase price and quantity is getting confused as the respective columns are located 100 columns distance. Is there any possibility...

Dear Excel Genius The below formula in the excel table, drag across right is not updating correctly. =LET(q,Consumption[Consumption RM01],p,Purchase[Price RM01],s,Purchase[Qty RM01],sa,SCAN(0,s,LAMBDA(a,v,SUM(a,v)))-s,qa,SUM(q)-sa...

Dear Excel Genius I would like to feed some more information about the LET and LAMBDA function and how it works. The below-linked thread has all the information from the scratch on why the LET and LAMBDA functions were created and it is the way of calculations. I am expecting your valuable...

Dear Excel Genius In the attached excel file Production sheet I am using the below formula (DU:FR) to get the Raw Materials cost per kg by FIFO Method. Due to more rows and columns of data the excel sheet is getting slower in the process for each entry. For example, I added 150 recent rows...