Carla1973
08-10-2018, 03:21 AM
Hi,
Please help. I have a headache from setting up these macros now.
I currently have the Submit macro to run so that it pastes the information from the purchase requisition sheet into the next available row on the log sheet. However, this won't work if any data isn't completed sooooo my question is two fold.
1) Is it possible to ask VBA to check all mandatory fields are entered on the purchase requisition sheet and bring up a message to warn the user and not run the macro if they are not?
2) How do I change the code so that, instead of pasting to the next available row, the purchase requisition number in cell G2 does use this method, but then all other columns in the log sheet are populated by looking up cell G2 from the A column in the log sheet and returning the relevant information to the correct column in the log sheet from the purchase requisition sheet? I then also need to apply the same to the approve macro so that it pastes to the correct row in the log as they may not be approved in order.
I hope this makes sense. I have attached a sheet with some sample data in so that you can see what I mean.
The password to unprotect sheets is Twins0105.
I will be eternally grateful :-)
Please help. I have a headache from setting up these macros now.
I currently have the Submit macro to run so that it pastes the information from the purchase requisition sheet into the next available row on the log sheet. However, this won't work if any data isn't completed sooooo my question is two fold.
1) Is it possible to ask VBA to check all mandatory fields are entered on the purchase requisition sheet and bring up a message to warn the user and not run the macro if they are not?
2) How do I change the code so that, instead of pasting to the next available row, the purchase requisition number in cell G2 does use this method, but then all other columns in the log sheet are populated by looking up cell G2 from the A column in the log sheet and returning the relevant information to the correct column in the log sheet from the purchase requisition sheet? I then also need to apply the same to the approve macro so that it pastes to the correct row in the log as they may not be approved in order.
I hope this makes sense. I have attached a sheet with some sample data in so that you can see what I mean.
The password to unprotect sheets is Twins0105.
I will be eternally grateful :-)