how do i set up a link between one excel cell from an access cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have an access database with employee information including salaries. I
want to link the salary into an excel spreadsheet to budget for the upcoming
year. I want to link these cells so that any change in the database will
automatically change in excel. this has proved hard as the links are always
by a set of data, not individual cells. Does anyone have any solutions.
 
If you want to link multiple cells, let's say A2:B40, first select A2:B40,
then copy (ctrl + C)
now select where you want the link(s), do edit>paste special and click the
paste link (lower left of the window)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I populate a cell with data from a cell in another workshe. 1
Carry data into a new budget year w/o original file path name? 2
Linking Cells Between Excel Documents Question 3
How do I link cells between to sheets in MS Excel? 3
How do I change the links in Excel at one batch? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I easily link a block of cells in one spreadsheet to anothe 2
can I link my Excel Cells to a table in a Word Document 5

Back
Top