Difficult but not impossible

[decent_boy]

Hello, hope that you are well

I need a macro for my result sheet , let me explain you that i have sheet1 and there are 3 fields from col a to c and i need a macro for result sheet which matches ID number from result sheet col a (where DI# is blank in col b) with sheet1 col a and copy/distribute b col value from sheet1 to result sheet in col c which must be equal d col value , ok please see below example in red highlighted font cells as a macro result.

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Sheet1[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl63"]ID[/TD]
[TD="class: xl63"]EDI #[/TD]
[TD="class: xl63"]Qty[/TD]
[/TR]
[TR]
[TD="class: xl63"]A11[/TD]
[TD="class: xl63"]A1245[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"]A11[/TD]
[TD="class: xl63"]A1345[/TD]
[TD="class: xl63, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"]A11[/TD]
[TD="class: xl63"]A1545[/TD]
[TD="class: xl63, align: right"]10[/TD]
[/TR]
[TR]
[TD="class: xl63"]A16[/TD]
[TD="class: xl63"]B4567[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"]A16[/TD]
[TD="class: xl63"]B6789[/TD]
[TD="class: xl63, align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 299"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Result Sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]DI#[/TD]
[TD]EDI #[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1245[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1345[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1545[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD="align: right"]2345[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A13[/TD]
[TD="align: right"]3245[/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B4567[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B6789[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B6789[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[decent_boy]

if need further explanation regarding to this can i explain if my question can not understand or it is not possible to be resolved.

 

[decent_boy]

Can Someone please provide the solution if it can be resolved or not

 

[Rick Rothstein]

How do the quantities shown on Sheet1 relate to the quantities show on the Result sheet?

Why is B6789 repeated twice on the Result sheet?

 

[decent_boy]

Thanks Rick for your reply please note that sheet1 is source data and by matching ID, result sheet is extracting data from sheet1 as per given Qty in sheet1 like if you see that result sheet example ID- A11 having Qty 2 and result sheet extracted EDI# which ID qty is 2 in sheet1 and after given 2 EDI # Qty is finished then it goes to next A11 where is qty is 1 and then it goes to next A11 where is qty is 10 but result sheet requirement is 1 in fourth row

Why is B6789 repeated twice on the Result sheet? sorry it is wrong entry

 

[yesterdays]

So correct me if I'm wrong the EDI # value depend on the Qty of that ID right?

E.g:
[TABLE="class: cms_table, width: 192"]
<tbody>[TR]
[TD="width: 64"]Sheet1[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]ID[/TD]
[TD="class: cms_table_xl63"]EDI #[/TD]
[TD="class: cms_table_xl63"]Qty[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]A11[/TD]
[TD="class: cms_table_xl63"]A1245[/TD]
[TD="class: cms_table_xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]A11[/TD]
[TD="class: cms_table_xl63"]A1345[/TD]
[TD="class: cms_table_xl63, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]A11[/TD]
[TD="class: cms_table_xl63"]A1545[/TD]
[TD="class: cms_table_xl63, align: right"]10[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]A16[/TD]
[TD="class: cms_table_xl63"]B4567[/TD]
[TD="class: cms_table_xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]A16[/TD]
[TD="class: cms_table_xl63"]B6789[/TD]
[TD="class: cms_table_xl63, align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: cms_table, width: 299"]
<tbody>[TR]
[TD]Result Sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]DI#[/TD]
[TD]EDI #[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1245[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1345[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]-[/TD]
[TD]A1545[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD="align: right"]2345[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A13[/TD]
[TD="align: right"]3245[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B4567[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B6789[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]-[/TD]
[TD]B6789[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

so if the " 1" change to 2 , the A1545 will become A1345 right ?

 

[decent_boy]

yes you are right

 

[decent_boy]

Can anybody please answer it ?

 

[Rick Rothstein]

Can anybody please answer it ?

I would like to help, but quite frankly, I still do not understand the logic behind the construction of the Result Sheet. It seems that 'yesterdays' does, in fact, understand it; so, unless you can describe in more detail the link between your data and the Result Sheet, I think you are going to have to wait for him to come back on line and pick up where he left off.

 

[decent_boy]

I would like to help, but quite frankly, I still do not understand the logic behind the construction of the Result Sheet. It seems that 'yesterdays' does, in fact, understand it; so, unless you can describe in more detail the link between your data and the Result Sheet, I think you are going to have to wait for him too come back on line and pick up where he left off.

Rick what you need to know more please ask I will explain but I give short example here suppose in sheet 1 in col a there are different and same name fruits and in column b their unique serial number and in column c fruits quantity
You are told to distribute these fruits in result sheet as per conditions.
Match fruit name with sheet
Give fruit (means copy EID #) from sheet 1 to result sheet as per given quantity of result sheet
once matching fruit quantity is ended in sheet 1 then go to next matching fruit name and copy data from their