Excel Macro for copy row to another workbook.

Hello,

New-ish to excel and I'm helping improve systems at the work place.

The issue is I want to be able to copy a row. e.g.

| New | 12345678 | company name | date | todays date | Name |

and then to a pre-saved excel spreasheet, paste the selected as a new entry/overwrite.

This will all be done as a click of the button on screen.

It needs to include a search of the number in the row copied, in the excel spread sheet it is being copied too and if the spreadsheet contains the number already: to over write it. If it does not: to create a new entry into the spreadsheet. The spreadsheet would then be saved and ready for the next entry.

I have no idea whether this can be done, but I have seen copy and paste between sheets on one workbook so I thought I might ask.

I look forward to your replies!

Kind regards,


orchslayer