Hi
I would like a macro/VBA code
to be able to Cut the data from range A6:a8 (has a formula to populate the values) on worksheet ABC then to paste as values to the next empty row on worksheet CDE in column B then have a message box say data copied. eg paste values to B12345 which is the next empty row etc, etc in worksheet CDE
Also if there is data in range A6:a8 on worksheet ABC when file is closed that it stops the user from closing the file until the range A6:A8 on worksheet ABC does not have data in them.
This workbook is populated on a very regular basis and I wish to take away all the manual work to do this. The above is manually done and takes time. I though using a Macro/VBA would help
Hope you can help with these. I do not know much about Marco/VBA
Thanks in advance
I would like a macro/VBA code
to be able to Cut the data from range A6:a8 (has a formula to populate the values) on worksheet ABC then to paste as values to the next empty row on worksheet CDE in column B then have a message box say data copied. eg paste values to B12345 which is the next empty row etc, etc in worksheet CDE
Also if there is data in range A6:a8 on worksheet ABC when file is closed that it stops the user from closing the file until the range A6:A8 on worksheet ABC does not have data in them.
This workbook is populated on a very regular basis and I wish to take away all the manual work to do this. The above is manually done and takes time. I though using a Macro/VBA would help
Hope you can help with these. I do not know much about Marco/VBA
Thanks in advance