tanasescu490
New Member
- Joined
- May 16, 2023
- Messages
- 1
- Office Version
- 2016
Hi guys!
My name is Eduard and I am fairly new to VBA. I have a hard time finding a way to create a form that allows me to send values from an entry point to a "so called database". What I need exactly is a code that will allow me to copy
values from 2 cells to another 2 cells in another sheet. Those two cells are dynamically changed based on two criteria (P.O.D and Month) and basically the values should be pasted at their intersection. The form is on Sheet1 and database on Sheet2. When I change the Month and ID, enter the values for SUM1 and SUM2 and press the button called "TRIMITE" the values from SUM1 and SUM2 should be copied on the same raw as ID and on the right column based on Month. Basically at the intersection between ID's raw and Month columns (SUM1 and SUM2).
I know that this is not the happiest structure to work with but I couldn't find another solution since there are over 330 total IDs that should have data populated in the right cells for each month. I'll provide any other information requested if my post isn't clear enough.
Thank you!
EDIT:
By P.O.D I'm referring to ID. I did a mistake there.
My name is Eduard and I am fairly new to VBA. I have a hard time finding a way to create a form that allows me to send values from an entry point to a "so called database". What I need exactly is a code that will allow me to copy
values from 2 cells to another 2 cells in another sheet. Those two cells are dynamically changed based on two criteria (P.O.D and Month) and basically the values should be pasted at their intersection. The form is on Sheet1 and database on Sheet2. When I change the Month and ID, enter the values for SUM1 and SUM2 and press the button called "TRIMITE" the values from SUM1 and SUM2 should be copied on the same raw as ID and on the right column based on Month. Basically at the intersection between ID's raw and Month columns (SUM1 and SUM2).
I know that this is not the happiest structure to work with but I couldn't find another solution since there are over 330 total IDs that should have data populated in the right cells for each month. I'll provide any other information requested if my post isn't clear enough.
Thank you!
EDIT:
By P.O.D I'm referring to ID. I did a mistake there.
Attachments
Last edited by a moderator:
