Hi L you would do better to post the workbook so that the user can see the line where it drops out Rob
Hi iulian No file attached ? Rob
Hi Bill Sorry for the delay have been on holiday in Greece If the sheets do not contain headers then change the Offset from (1) to (0) as below ...
Hi Bill See attachment, i am presuming there are headers on all sheets ? Rob
Eric this is a lot faster ok Rob
Eric You could try this, not tested and also col B does not comply with what you have asked for Sub transfer() Dim i As Long, lastrow1 As Long D...
Hi Eric Some problems in your vba code myname is a string not Double you don't need to select cells slows the routine down You could use the sam...
Hi David To get to the code right click on worksheet tab and select view code Click on UF1 and click on command button to see code for it The...
Hi David This routine attached will copy data from sheet1 to sheet2 You can use partial search as well in the input box on the user form Hav...