I need help with a Copy/Paste but if cell has data then paste here code.
On my "Main" sheet I have data entry for account numbers and names and also product selections. When Data is entered onto the Main sheet I currently have it copied and pasted to a special (nice looking printer) Sheet named Print. When products are selected for accounts, the output data is also already copied/pasted to my Print sheet, and the selection of products also unhides hidden pages specific to the products.
On the pages I want to create a Command Button that does the following:
1. Searches Print A77 for product AR selected for Account 1, if AR is in A77, then Print C11 is copied and pasted to Sheet AR D11.
This next part is what I need help with:
2. Searches Print B77 for product AR selected for Account 2, if AR is in B77, then Print C12 is copied and pasted to Sheet AR D11 but if AR D11 already has data, then it needs to copy to AR H12.
I need to be able to always have the first "Paste" cell as the first option, but if it has data then specify a next cell, and either paste there or if it already has data then paste to another different cell.
Any suggestions/advice/help would be GREATLY appreciated.
On my "Main" sheet I have data entry for account numbers and names and also product selections. When Data is entered onto the Main sheet I currently have it copied and pasted to a special (nice looking printer) Sheet named Print. When products are selected for accounts, the output data is also already copied/pasted to my Print sheet, and the selection of products also unhides hidden pages specific to the products.
On the pages I want to create a Command Button that does the following:
1. Searches Print A77 for product AR selected for Account 1, if AR is in A77, then Print C11 is copied and pasted to Sheet AR D11.
This next part is what I need help with:
2. Searches Print B77 for product AR selected for Account 2, if AR is in B77, then Print C12 is copied and pasted to Sheet AR D11 but if AR D11 already has data, then it needs to copy to AR H12.
I need to be able to always have the first "Paste" cell as the first option, but if it has data then specify a next cell, and either paste there or if it already has data then paste to another different cell.
Any suggestions/advice/help would be GREATLY appreciated.