Hi,
I have many workbooks (called project planners), each is set up for a different project. A summary of the project data is saved on one row of a particular worksheet (projsheet) in the project planner. Each row (or project has a unique identifier or project number (e.g. B1100), which is recorded in a single cell within the row.
I want the users to be able to send the data in this row to another (central) workbook saved in a different location (mastersheet). When the row is pasted into the new sheet I would like the code to check if the job number already exists, if yes I would like the record to paste over the existing record and if no I would like the data to paste to a new row.
I would really appreciate any help that anyone can offer!
I have many workbooks (called project planners), each is set up for a different project. A summary of the project data is saved on one row of a particular worksheet (projsheet) in the project planner. Each row (or project has a unique identifier or project number (e.g. B1100), which is recorded in a single cell within the row.
I want the users to be able to send the data in this row to another (central) workbook saved in a different location (mastersheet). When the row is pasted into the new sheet I would like the code to check if the job number already exists, if yes I would like the record to paste over the existing record and if no I would like the data to paste to a new row.
I would really appreciate any help that anyone can offer!