LInking databases (to and from worksheets)

  • Thread starter Thread starter rosie7
  • Start date Start date
R

rosie7

Hello,

I need to create a new worksheet that contains data that can link from an
already existing excel database. In this worksheet I only need certain
categories and data presented. Ideally, any new revisions or additions made
in this database will automatically be reflected in the worksheet. I need
to figure this out for a new job and I'm completed stumped. Help!

Can anyone help me out with this one?

Rosie7


..
 
It's hard to tell what exactly you want to do Rosie.
I don't know how familiar you are with Excel, so maybe you know already
everything I tell you and your problem is much more complex.

You can link a cell in an Excel file (lets say File2) very easy to a cell in
another Excel file ( your database ; lets say file1) by opening both your
files and then in File2 build up the link to a cell in File1 by pressing =
and then "switch" to File1 (either by Cntr Tab or Window / File1 from the
menu) selecting the sheet your cell is and then clicking that cell (lets
assume : Sheet1 and cell A1). By hitting the Enter key then the formula is
build up in File2.

As long as both file2 are open, you see as a formula something like :
=[File1.xls]Sheet1!$A$1 (the dollarsigns shwo that the linkk is absolute,
meaning that copying the cell down (or aside) to another cell stys referring
to the same cell. If you want to "move" the link as well (thus in Cell A1
you want A1 from File1; in cell A2 you want A2 from File1 etc. , you should
remove the $. The link then becomes a relative one.

As said, if this is all very basic to you, it wasn't meant to offend you,
but just because I didn't know where your problem was and whether I could
help with it or not.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top