I have one workbook with 12 worksheets...11 are Master Sources that have all been copied with the Paste Link feature into the 12th worksheet.
My question is: Is there a way to auto update the 12th one if new data is entered (NOT edited) on one of the 11? It would be nice to not have to copy and paste special everytime a new line of data is entered -- multiple people will be handling this workbook and I'm concerned that someone will forget this important step.
Thanks.
My question is: Is there a way to auto update the 12th one if new data is entered (NOT edited) on one of the 11? It would be nice to not have to copy and paste special everytime a new line of data is entered -- multiple people will be handling this workbook and I'm concerned that someone will forget this important step.
Thanks.