Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link Cells from one spreadsheet to another
I have an .xls spreadsheet that has many products on it. When I get an over all price increase by $.05 I can just put in the increase amount and all my Products on that page will then show the new cost for the individual items. LETS call this the Price Increase .xls sheet Lets use the product Anklets as an example: The new cost price for Anklets is now calculated to be $.95. This cell is linked to another .xls spreadsheet (Anklets Cost sheet) that has maybe 15 anklets on that page. I have a column for item costs and a column for Sales price, as well as other necessary data columns. So all the cost and sales prices are automatically updated for Anklets when I change the price in the Price Increase page .xls The big problem is that I need to update my web site with the new prices via a .csv file that I call my Anklets csv Upload file. It is in this file that I setup a link to the prices in the Anklets Cost sheet.xls), which were automatically changed when I put the new increased amount in the Price Increase .xls sheet. When I have the Anklets csv Upload file On the screen and set up the link i.e. ='[Price Update.xls]Sheet1'!$H$34, the new price from the Anklets cost sheet does show up in the .csv Anklets csv Upload file on the screen. But when I save the file and try to re-open it the link is gone. If the link in the .csv file to a cell in the .xls file is gone I cant change my upload files automatically. Any help would be appreciated . Bricap |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
A spreadsheet will not link to cells in another spreadsheet? | Excel Discussion (Misc queries) | |||
How do I link text from mulitple cells to another spreadsheet | Excel Worksheet Functions | |||
Has anyone tried to link cells in a spreadsheet to a graphic? | Excel Discussion (Misc queries) | |||
Can I link single cells in a spreadsheet to another worksheet? | Excel Worksheet Functions |