Home » Forums » Open Source Learning Center » Question and Answer

Use entries in one sheet to populate several sheets on different Network shared drives -

Submitted by gipbrown on 1 April, 2012 - 18:08

Hello all - At work there a several Excel sheets and an Access DB on different Network shared drives that I update daily which contain some duplicate information. So, instead of opening them all and making the entries, is there a way I can have the entries in the sheets and DB get the data from the other sheets and DB?

There is also a label that needs to be created on occasion from information in all the sheets and DB and was curious if there is a way to create the label from the data in the sheets and DB.

Thanks in advance for any assistance,

Gip

‹ VBA Help--Access--Compiler Error:Type Mismatch Find multiple entries ›
»
Almir's picture

Use entries in one sheet to populate several sheets on different

Submitted by Almir on 29 October, 2012 - 11:26.

Several solutions... I suggest linking Excel sheets and another DB tables in target Access DB. Then, create query (or more queries) which will update target DB tables with data from source sheets and DB.If this is too DB stuff, contact your DB Administrator or provide some example files.

»