Posts by gentle_20052006

Your instructions are not understandable. provide clear task to do

Thank you very much.

Help arrived at right moment. Mission completed.

Thank you very much KjBox.

When I applied code in the actual data, the requirement not fulfilled. I failed to foresee the outcome.

Can I get my revised qty as followed in column" E" if possible?

Thanks

Thank you KjBox. It worked WOW thank you

Thanks for your quick response.

The each lines should be intact/line wise i.e if input contains 100 rows I need required value column "d" for all 100 rows.

The logic for Required colum "D" is

A. The Gross qty of A, b, c, d, e, f, and G are 30,77,98,34,180,10 and 22 respectively.

1. Gross qty "A" of 30 should meet from line qty of "A" from 12 & 23. In meeting so,12 will get "exhausted" first and column"d" goes blank, then goes to 23 and from 23, only 18 will get "exhausted" from it and the remaining 5 is placed in column"d" against the row containing line qty 23.

2. Gross qty "b" of 77 should meet from line qty of "b" from 45,30, & 2. In meeting so, 45 will get "exhausted" first, then 30 gets "exhausted" and 2 gets "exhausted" from line qty and there is no remaining column"d" against all rows containing "b".

3. Gross qty "G" of 22 should meet from line qty of "G" from 30 & 30. In meeting so, 22 will get "exhausted" first, the remaining 8 is placed in column"d" against the row containing line qty 30. since we have exhausted gross qty from ""B17", the next 30 in "B18" goes to column"d" without any deduction.

Hope I am able to explain the logic. Still looking for formula/VBA code.

Thanks

Hi all,

I need the required qty based on the line qty and gross qty.

The Required qty is the difference of total line qty and gross qty. I need it line wise that's where I am not able to apply formula.

Column "D" is required for Formula or VBA code.

Pls help me to resolve the attached problem.

Thanks

Pls some one help me

Thanks pike. I will try to understand your code as I am a VBA learner . This would enhance my knowledge.

Thanks once again

Thanks KjBox so nice of you to comment the code to understand.

Good work and help. This is the reason why I am here for last 10 years.

Thanks

Thank you. It does exactly what I want to do. But as a novice I need to decode the meaning of code. Great hep at the time of need.

Thanks once again.

Treat this thread solved.

I am a novice pls excuse me

As desired code is here in the attached sheet

Thanks for your time

Thanks for your quick reply. But i am not able to populate the output sheet as desired. Looking forward some help...

Hello,

I am seeking help from experts in this forum to help to resolve the following issues other than Pivot table by using ExcelVBA.

1. I am getting data "input" list from different users so the column heading is same but located in different column number from each user. ex. Posting date is in column "A", but from different user it can be column "D". same way products and quantity also.

2. I want to summarize the data as per "Output" sheet.

Since I know how to tweak the code to suit my requirement, i can use this code to generate daily and weekly report. Thanks

Pls someone help me to get rid of the above problem. It is happening routine so i need suitable formula or VBA code to resolve it.

Dear AD

Step through the code by pressing F8 instead of F5. You will see what is happening in excel when you press each time F8. Learn how to use Watch window and immediate window. These are useful feature. The real learning is by doing it. Try it you will love it.

Roy,

The problem is I have each item in sealed condition and loose(seal opened) condition. Sealed items are in Litres. Total qty in litre to be displayed in column F. But I want to convert sealed Litre qty into kilogram using density in column J.

in case of loose qty in kilogram, the gross weight and tare weight is given. we need to arrive the net qty in kilogram in column J.

User Input column: A B C D E G H I

Output Needed column: F J K

1. Each sealed item in litre should be summed up (Multiply) in column F and net qty in kilogram should be summed up in column J (Multiply column F and density).

2. Each loose item should be arrived net qty in kg in column J by subtracting tare weight from gross weight.

3. The grand total for each item should be summed up in column K by adding all net qty in kg for that particular item in column J at the last instance of that item.

Hope i am able to explain the problem.

Hello !!!

I want you guys to solve my problem using VBA since it runs 1800 rows of data which need to be manually done as it pose error.

Hope to get Code sooner.

Thanks in advance.

attach sample file

Thanks Trunten

Upload a sample file