cc11
New Member
- Joined
- Apr 6, 2021
- Messages
- 48
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
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).
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.
MAT. Balance PO(0)
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).
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.
MAT. Balance PO(0)