While you can write a Formula-URL field that displays as a button and will create a record in another table and populate data fields with fields from your source table; you might also want to consider a table-to-table import. This would allow you to create all the records in a quick and easy process. You would build your table-to-table import and save it so that each time you activate it, the mapping is already programmed to create records in your new table from the data in your source table. All you would need to do is to "identify" somehow the records in your source table that you want to move and use that identifier in your criteria for the table-to-table import.
If you are creating tens or hundreds of records; and your data is being wiped and repopulated weekly; this would be a far more efficient method.
