Match cell value, copy/paste adjacent cell data

[canarycat123]

Hi there, I’m hoping someone can help provide some guidance to achieve the below:

I have two sheets: Sheet1 is the “Master Sheet” which contains unique reference numbers in column A followed by a large range of data along the row. Sheet2 is being used to capture a common portion of that information for ease of usability. Within Sheet2 are reference numbers in column A, which are a mirror image of those in Sheet1.

Occasionally data in Sheet2 will be amended and therefore needs to be reflected in Sheet1 against the applicable reference number. E.g. amendment made in cells B2:E2 (Sheet2), code (linked to button) identifies reference in A2, copies data, then matches to the identical reference in Sheet1, then pastes the values into the applicable range (e.g. Sheet1 F7:I7).

I hope this makes sense. If anyone can help that would be appreciated.

 

[PeteWright]

Hi,

I don't know how the others deal with it, but for me it's really hard to provide a solution without a sample sheet / workbook.

You can use XL2BB to paste your sheets to the forum.

Best practice is to show 2 tables:
- table one with sample data
- table two with result data

 

[canarycat123]

Hi,

I don't know how the others deal with it, but for me it's really hard to provide a solution without a sample sheet / workbook.

You can use XL2BB to paste your sheets to the forum.

Best practice is to show 2 tables:
- table one with sample data
- table two with result data

Hi there, thanks for your response. Unfortunately, my employer doesn’t allow third party add-ins so can’t use XL2BB, however, I have attached two screencaps.

‘Image 1’ is the master sheet, and ‘Image 2’ is the data entry sheet. As an example, if I were to add data to C9 on ‘Image 2’. Upon clicking the button, the code would be able to identify the ref no from the corresponding cell in row A, A9 in this case, match that with the identical ref in ‘Image 1’, cell E3, and paste the newly entered data to X3.

There are many rows of data in each sheet, going into the thousands, so would need to be able to identify changes across the whole data entry sheet. I hope this makes sense?