Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
interactive databases
I need to have one worksheet in two different databases (i.e., "clients" )
that is the same in noth in other words whenever we update names and addresses in the clinets tab of the first workbook it is updated in the second and vice-a versa. Is there a way to do this simply? Being able to updtae the information in one workbook and have it updtaed in the other, only is no longer useful due to many users using both. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
interactive databases
Why not keep one master clients sheet? How are you using the clients database? VLOOKUP will work across workbooks, even if the master clients is closed. -- royUK Hope that helps, RoyUK For tips & examples visit my 'web site' (http://www.excel-it.com/) ------------------------------------------------------------------------ royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining databases | Excel Discussion (Misc queries) | |||
databases | Excel Worksheet Functions | |||
Databases | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) | |||
DATABASES | Excel Discussion (Misc queries) |