I am in a bit over my head on this project. This may be a simple macro but but I just can't figure it out or if it possible.
Problem: I created a form (Dialog1) I can pull information from other worksheets, but I want to assign a macros something like this to put the data in another sheet upon sumbit.
Example, when I hit sumbit I would like Edit Box 10 to move to worksheet3, add a line find the cell and copy the information to (example to D3)the cell . Edit Box 11 to perform the same function but paste data into (example D4). Next time I want the record to go to E3, paste to E4, etc.
Can these forms be used for this purpose. Access is better for this but doesnt have the graphing capabilites Excel does.
Problem: I created a form (Dialog1) I can pull information from other worksheets, but I want to assign a macros something like this to put the data in another sheet upon sumbit.
Example, when I hit sumbit I would like Edit Box 10 to move to worksheet3, add a line find the cell and copy the information to (example to D3)the cell . Edit Box 11 to perform the same function but paste data into (example D4). Next time I want the record to go to E3, paste to E4, etc.
Can these forms be used for this purpose. Access is better for this but doesnt have the graphing capabilites Excel does.