Okay - let me try and explain what I am trying to do. It should be pretty straight forward
The below code copies the values for cells "K2,B8,G13 &K5" from Worksheet - Order_Sheet and pastes them into "N1,M1,L1,K1" on Worksheet - Database_Sheet - When I click on the Transfer button that I have linked to the Code.
Which is great! However what I am trying to do is to keep a running database - so each time the button is clicked it should transfer the data to the next empty row for each cell I.E. N2,M2,L2,K2 - N3, M3, L3, K3 .... etc, etc
As an additional bonus - if a message or popup box could be popup and say "the Data has been transfered"
Bookmarks