watkins6878
Board Regular
- Joined
- Nov 26, 2005
- Messages
- 96
Hi All
The problem i am having is this: I have a Workbook with two worksheets
Sheet1 has 6 columns (Delivery NO,Customer,Store,order No,size,Drops
on this sheet i run a macro to find a delivery No and display its location, I would like to be able if possible to copy the contents of the row then have a userform which i enter a load No and Drop No in and then paste this to the next empty line in sheet two which has 8 columns in
Load No,Drop No,Delivery NO,Customer,Store,order No,size,Drops
Any tip would be helpful
thanks in advance
The problem i am having is this: I have a Workbook with two worksheets
Sheet1 has 6 columns (Delivery NO,Customer,Store,order No,size,Drops
on this sheet i run a macro to find a delivery No and display its location, I would like to be able if possible to copy the contents of the row then have a userform which i enter a load No and Drop No in and then paste this to the next empty line in sheet two which has 8 columns in
Load No,Drop No,Delivery NO,Customer,Store,order No,size,Drops
Any tip would be helpful
thanks in advance