In my attached Excel file on worksheet named "Main" there is a table where numeric values are keyed in.
In worksheet named "Series1", you'll see another table that has values that populate through a VLOOKUP function that assesses the table on worksheet "Main" to return the correct value in "Series1!F7" for example.
As it stands write now, updates entered in Main will be reflected on Series1 by means of the vlookup. However, updates entered in Series1!F17 will NOT be reflected in Main!G19 for example (this is obvious, because there is no formula linking them together).
What I would like to do is, when a value is entered in a cell within the table on Series1 worksheet, I want that value to populate in the corresponding cell in the table on Main worksheet. Then after it populates the correct cell in Main, the cell in Series1 will return to its original state (note, its original state contained a VLOOKUP formula that was obviously over written when a new value was entered).
I think this question should be worth 1,000 points, but unfortunately 500 is the max. Thanks for any helpful feedback. =)