Sort Data From Multiple Worksheets (as generated) into a Column Depending on Data Entered on Another Column

[cc11]

Hello everyone,

I am looking for either a formula or a macro code, whichever is easiest, but I have three sheets labeled "Mat. Balance", "PO Log", and "PO (0)". Now just to get a grasp of how the workbook functions now is that on the "PO Log" I have a button assigned to a macro that every time I click it, it generates a new PO (0) in numerical order, so PO (1), PO (2), and so on for as many times as I press the button.

What I am now needing to do is incorporate the "Mat. Balance" sheet with the "PO (0)" sheet and each one that follows after that, for as many that I generate. The "Mat. Balance" sheet has 4 columns A, B, E, F, and G. The columns that need to be worked out of are only A and F. Those range from "A4:A118" and "F4:F118". On column A information will be entered, a number, and on column F it will automatically populate in a number(dollar amount) depending on what was entered in on Column A. In the "PO(0)"(and for as many as I generate) the two columns information will be coming out of it "A21:A48" and "I21:I48". On column A information will be entered, a number and on column I the information is automatically populated in and is a number(dollar amount).

On the next post I will add pictures and explain what I want it do exactly so this post isn't crazy long.





@Joe4 not sure you can help again but this is out of the same PO Log you helped me on a few days ago.

 

[cc11]

So to get into what I want it to do:

So for each PO(0) that is generated (so 1,2,3,4,5,etc.) I am wanting it to (refer to PO(0) pic) to take the information that is entered through A21-48 and Match it (refer to Mat. Balance pic) to whatever info was entered through A4-118 and then whenever it does that, whatever matches it, it will take only what matches it and take a sum from PO(0) I21-48 and enter it on Mat. Balance F4-118.

Let me know if I need to explain this better.

 

[cc11]

Can anyone help me out on this?

 

[cc11]

Still am needing help on this ASAP!! Please can someone help!!

 

[cc11]

Haven't had a reply yet... Can someone help me out on this?

 

[cc11]

Bump!