Thank you JBeaucaire...
This works exactly as I had requested. This takes data from worksheet 'OPL' and transfers it to the first column of worksheet 'OPL Database' after the last entry.
Is there a way to change this code so that data is transferred into the first available column instead of the first column after the last entry. In the database that I am trying to create I might have to clear some data from a row and I would want the next set of transferred data to go into this available slot.
Also the hyperlink that I am trying to create is in column 'O' of worksheet 'OPL Database'. Basically user enters data from a multipage userform in worksheet 'OPL' and this data is transferred (thanks to your code) to 'OPL Database'. Once this data is transferred through the SaveAs macro, I am trying to get it to create a hyperlink to it's saved location.
I have attached a copy of my workbook. If anyone can help me I would appreciate it. Hope I have explained what I am trying to accomplish well enough.
Thanks
Bookmarks