Let me try again. I would like to take data from workbook A and have it update mirrored workbook B using a data connection. When I make a change to workbook A I want it to update in workbook B when refreshed. I have about 12 people using workbook B so I need the connection to work even if being used. I brought access into this because I have not been able to accomplish this going from workbook A to B. Any help would be appreciated.
|