Transfer Data To Another Worksheet And Create Hyperlink

Rookie needs some help...

I have a SaveAs macro that saves the worksheet into another workbook at a specified location. I need to add to the code. Would like to transfer data from one worksheet into the next available row in another worksheet. I have searched and seen multiple variations of this and I know this is probably cake for experienced programmers but I can't get it right. Is it also possible to create an automatic hyperlink in a cell based off my new saved location.

To summarize what I am trying to do:

Take data from cells N10:W10 in worksheet 'OPL MASTER' and transfer them to the next available row in worksheet 'OPL DATABASE'. I am trying to get it to create a hyperlink in the next available column that this data is tranferred to.

Any help is appreciated!

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Oops, forgot to attach my workbook...

This works fantastic. I can't thank you enough.