# Recent content by Anbuselvam K

1. ### Export as pdf depends on number of validation list

Thanks a ton Boss.
2. ### Export as pdf depends on number of validation list

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.
3. ### Export as pdf depends on number of validation list

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...
4. ### Export as pdf depends on number of validation list

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...
5. ### Export as pdf depends on number of validation list

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...
6. ### Find OUT KG Occurrance an IN KG then Multiply with Price

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...
7. ### Find OUT KG Occurrance an IN KG then Multiply with Price

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.
8. ### Find OUT KG Occurrance an IN KG then Multiply with Price

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...
9. ### Find OUT KG Occurrance an IN KG then Multiply with Price

@Marc L I have filled all the D column Values manually. I hope now it is explained well.
10. ### Find OUT KG Occurrance an IN KG then Multiply with Price

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...
11. ### Formula drag across right is not working!

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...
12. ### Formula drag across right is not working!

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...
13. ### Formula drag across right is not working!

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...
14. ### VBA Code to replace Let and Lamda Functions.

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...
15. ### VBA Code to replace Let and Lamda Functions.

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...