Maintaining links for imported data
I have a workbook with 20 sheets. One summary sheet links to 19 back up
sheets. I have been asked to email each backup sheet to a different engineer
so they can enter revised data. They will then email the updated sheet to me
and I need to import that new data back into the back up sheets such that the
summary sheet is still linked to the back up sheets. Does anyone know how to
do this?
|