editing across sheets for text consistency

Cheryl Miller

Hi all,

I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in from another sheet (there was much rejoicing!) but now am needing to be able to edit the info. Is there a way to do that without having to go back to the original sheet? For instance, the source sheets are Applications and awarded; the field to match is Project Name on the Awarded sheet. I'm hoping to be able to edit the Project Name on the Awarded so that it updates on Applications.

Here is the formula I used for the index match:

=INDEX({Applications Range 1}, MATCH([Grant #]@row, {Applications Range 4}, 0))

Once I get this down, there is a third sheet to incorporate...

Thank you to anyone who even understands what I'm asking, and extra thanks if you have a solution!

Paul Newcome

Reports can work both ways, but that only works for manual entry cells. Cells containing formulas are not editable in a report. The same goes for the premium app Dynamic View.

Paul Newcome

You are going to have to go back to the source sheet to edit the information. If you were to manually enter information into a cell containing a formula, it will remove the formula and overwrite it with whatever text you are entering.

Cheryl Miller

Thanks Paul. I thought I saw somewhere that there was a way to set it up to be able to edit both ways. Maybe I made up a memory?

Paul Newcome

Reports can work both ways, but that only works for manual entry cells. Cells containing formulas are not editable in a report. The same goes for the premium app Dynamic View.

Cheryl Miller

Ah - I see. thank you!