Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a link between one excel cell from an access cell
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a link between one excel cell from an access cell
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 editpaste 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 "Joy A." <Joy wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link a picture to a particular cell in excel? | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
EXCEL LINK CELL FORMULA | Excel Worksheet Functions | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
Trying to link MS Access to MS Excel | Links and Linking in Excel |