Replacing Cell Data

[JustinEP]

I wanted to start off by saying I really appreciate this forum, I have found a lot of great information here.

• My situation:

I have a workbook with two sheets. Sheet 1 has a list in cell A1. The list is populated with the names in Sheet2!A1:A100.

After selecting a name from the list on Sheet1!A1, the name appears in Sheet1!A2.

In Sheet1!B2 I use =match to determine which row the name was in on Sheet 2.

Sheet1!C2 contains the formula =indirect(D2).

In D2 I have a formula to state the cell I want the indirect reference to display, regarding the name selected in the list, from Sheet 2, using =text("Sheet2!K","")&B2. This shows me the data in Sheet2!K2.

• My question:

I want to be able to overwrite (or essentially update) the data in cell Sheet2!K2 from either Sheet1!C2 (where it is currently displayed) or a cell below or to the right of Shee1t!C2 (Sheet1!E2, Sheet1!C3, etc.)

How do I do this?

If you would like to see my sample book please feel free to ask!

• In other words: How do I create a formula that says: replace all data in cell (insert cell) with data in cell (insert cell).

Thank you all in advance for your kind support.

 

[JustinEP]

Please let me know if my question wasn't clear. I could really use some help on this!

 

[JustinEP]

I know I couldn't have stumped everyone that easily! Any ideas?