Copying Data to New Workbook and Update Rows

BLPew

New Member
Joined
Nov 8, 2011
Messages
1
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!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,223,308
Messages
6,171,331
Members
452,396
Latest member
ajl_ahmed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top