Linking Two Charts Within A Single Workbook
Jan 22, 2010
I will attempt to describe my problem the best I can. Thank you in advance:
I have a series of charts (and the tables in which the data for the charts is stored) located in a worksheet. I copied and pasted each one of these charts next to its original. I then moved each one of the new, pasted charts into a single chart sheet at the end of the workbook. Is there a way, via macro or otherwise, to update the charts now located in chart sheet if any changes are made to the original charts?
View 9 Replies
ADVERTISEMENT
Jan 10, 2014
Is it possible to make a copy of a chart that is edited simultaneously as when you edit the original chart...somewhere else in the same workbook.
View 1 Replies
View Related
Sep 25, 2012
I have values on master sheet and want to link those values to source documents in the same workbook. But the values on master sheets are made up of more than one value on another sheet.
For example on master sheet I have $137,000 that is made up of values in P7 + Q7 + P57 + Q57 on source sheet. If user wants to see where this number is coming from; the user will click the number to go to source document.
On a single valve I linked to the source sheet to a single cell. One thing I was thinking, using conditional format, so if one of the cells is selected in source document the other cells that combine the total of the master sheet cells should be highlighted, just my 2 cents.
View 6 Replies
View Related
Sep 18, 2006
I have a workbook Book1 that has 4 sheets, one of those sheets needs to be an exact replica of a sheet from another workbook Book2. I tried to directly link the data and use Vlookup's but the problem is that when someone opens Book2 and inserts more data (Inserting rows) it does not show up on Book1.
View 3 Replies
View Related
Apr 15, 2013
I am trying to link data from one workbook into another and get it to work but it puts in sample data or dates which I dont want. How can I set it up were the cells are blank until data is input in the main sheet and then linked to the destination sheet?
View 4 Replies
View Related
Nov 30, 2009
I'm using a macro to try to pull data from a worksheet but it only works when its opened. I found a macro that is supposed to get data from an unopened worksheet but I don't understand VBA very well so is there anyone here that could tell me how to merge my macro with this one to allow me to access the unopened worksheet?
This is the website for retrieve data from unopened worksheets:
[url]
And this is my macro I'm trying to use:
Function HyperLinkText(pRange As Range) As String
Dim ST1 As String
Dim ST2 As String
View 9 Replies
View Related
Dec 11, 2013
I'm trying to link specific data from one workbook to another. So from the demo I've attahced, I need all of the 3rd row "ATP BASIC SERVICE : 1" to be linked to another workbook.
So normaly I could copy the row, go to the other workbook, "paste special" and link it to a column.
The only problem is the "ATP BASIC SERVICE : 1" data will not always be on the 3rd row.
So i assume I would need to automatically search for "ATP BASIC SERVICE : 1" and if it is found, copy the column over to the other workbook.
View 4 Replies
View Related
Aug 14, 2013
I'm looking to link/embed a summary sheet from one work book to be displayed in another. When i update this summary sheet i wish for it to update the linked work book.
View 7 Replies
View Related
Apr 18, 2009
My question is as follows:
I have two workbooks in the same folder on a shared drive. Workbook2 is linked to workbook1. I have protected Workbook1 with a password protected to limit access.
When my collegues who use workbook2 try to open it, it asks for the password for workbook1 before opening. When they ignore that and go a head to open the file. The new information from workbook1 is not updated into workbook2.
How can i mentain my password in workbook1, and keep the files linked such that they can be able to see the new information in workbook2 without knowing the password for workbook1.
View 9 Replies
View Related
Dec 7, 2009
I have an excel sheet that has a list of codes and next to each code there is a price list for that particular item.
What I am trying to do it: I have another workbook that I use to type up quotes. In this workbook there are 2 columns: one with the code for the item and then another with the price thereof.
What I'd like to do is when I enter the code of the part, I'd like the price to be referenced from the other workbook and be entered into the price column.
View 9 Replies
View Related
Jul 15, 2004
I am trying to do a countif in another workbook.
I enter my formula:
=COUNTIF('path[filename]tab'!$AH$11:$AH$300,"yes")
So this formula works fine when I have the other workbook open, but the next day when I open up the file (with the formula in it) and I click "update" button on the "this workbook contains links to other data sources" popup I get a #VALUE! error in the cell. Does anyone know how to correct this?
As soon as I open up the linked workbook the error goes away, but I didn't think this is how its supposed to function. I thought you didn't have to open up any linked documents. All the documents are on my desktop, so its not a share drive issue.
To test it out, I tried doing just a simple link to cell A1 in the other workbook and that works fine, so I'm thinking its the COUNTIF function that causing the problem.
View 9 Replies
View Related
May 26, 2006
I am importing data from an outside excel file to several other files. I requested that the data be refreshed every time I open the file that references the outside excel file. Whenever I have a file open that references the outside excel file, I can only open the outside excel file in a read-only state. Why is this, and is there any way around this issue?
View 2 Replies
View Related
Jun 20, 2007
ive managed to come up with this formula: = OFFSET( 'G:gailMVTR2007[B052,B261A.xls]B261A45'!$B$5,COLUMN()-3,0,1,1)
which pretty much does the same job as a paste special/translate, this works fine when both files are open and updates all the values that i could ever enter, however, when i open only the file containing the link and press "update" it returns a "#value!" error, i dont understand because it works fine when the other sheet is opened and there are no values other than a single number used.
View 6 Replies
View Related
Jan 19, 2007
I have this workbook of an AR summary.
I would like Charts in there that pull from 'Sheet 1' and what i am trying to achieve is the chart always shows the most current data, as the data is entered weekly. Is it possible to have the graph constantly showing the data that is the most current?
The X & Y are
Total AR
10/22/06 10/29/06 ect.. 13 weeks of most recent data.
There are about 15 different graphs, and it is time consuming to have to go into each one of them and update all the series.
View 9 Replies
View Related
Apr 10, 2006
I've been updating charts from different workbooks to a destination workbook manually & it's getting a little too much recently. Need to writing a macro which prompts for the source & destination workbooks and to copy charts from source to destination workbooks?
View 5 Replies
View Related
Jan 9, 2007
We have a worksheet, which contains charts and data which requires updating by different department.
However, when I have this work- book as a Shared workbook (Tools - share workbook), The charting and macro has all been deactivated.
Would anyone have any idea on how do I share a workbook - while being able to also update the Excel Charts within it ?
(Different user will be updating different charts, and there will be no conflict in between them)
View 3 Replies
View Related
Jun 25, 2014
I'm trying to find a way to save a single sheet of an excel workbook and in the same process delete all vba code and shapes from the new single sheet workbook. I was looking around and found this code which does save only the single sheet to a new one sheet workbook but doesn't delete the vba and shape that I have used to assign macros to in the original.
Code:
Sub SaveSheetAsNewBook()
Dim wb As Workbook
Dim InitFileName As String
Dim fileSaveName As String
Dim wshape As Shape
InitFileName = ThisWorkbook.Path & Format(Date, "mm.dd.yy")
[code]....
View 2 Replies
View Related
Sep 17, 2009
I have multiple workbooks ( with unique names) under same folder. Each workbook has "Report-Corn" sheet.
I would like to copy cell "P15" from each (workbook-> report-corn -> P15) and paste to Master.xls workbook -> Sheet 1 one after another which is also located under same folder.
View 9 Replies
View Related
Mar 6, 2014
Using Dropbox, a lot of people will fill in formulas in personal workbooks from using data from another, central workbook. Since I cannot control where they install Dropbox or where they keep their personal workbooks, I must account for that in functions.
Now, my idea is to make them define the directory of the source in their personal workbook in a specific cell and then using that as a basis for the rest of the functions.
Example
Cell A1: C:Usersuser1Dropboxfolder (copy paste from path in Windows Explorer)
Cell B1: A1&[CentralWorkbook.xlsx]SheetName'!$H$1
Basically I want the unknowing user to copy-paste the path of the central workbook into a specific cell in their own workbook and then build my functions bsed on that. How can this be done?
View 2 Replies
View Related
Aug 12, 2014
I have a question regarding linking the content for data validation lists stored in a different workbook.
The scenario is as follows: I will have say 50 users using a template which contains various dependent drop-down lists. These lists work by using the INDIRECT function which calls the correct drop-down based on the previous selection. The drop-down entries are currently stored in named ranges on a hidden worksheet in each user's file.
However, if I need to make a change to the content of these lists, I will have to open all 50 files individually and change each one. So I'd like to have a master file to which all the templates would be linked which would contain the entries for each drop-down. So when I update a list in the Master file, it would automatically update the drop-down lists in each user's template with any additions deletions.
My question is, how do I create the links between the user templates and the master and have it so that the list ranges will be dynamic. So if a drop-down list contains say 10 entries and I add 2 more in the master, that those 12 now appear in each user's template?
View 3 Replies
View Related
Sep 27, 2008
A simple one for you, but again my Google skills seem lacking. This must be common practice but until one knows the key combination...
I have created a summary sheet with lots of formulas which analyse other sheets in a workbook. I want to copy this summary sheet to a seperate workbook to use as a template.
Of course, the copying process always links the new (template) sheet to the original workbook it was copied from. How does one copy without forging this link? All I want are the formulas copied across totally unchanged; I really *don't* want to manually edit 50 or so formulas!
View 7 Replies
View Related
Dec 27, 2012
At our small firm, each staff member keeps a small excel spread sheet on the network that contains their "work in progress." This spreadsheet is roughly six columns wide and roughly twenty lines long.
What I am attempting to do is have one "master" spreadsheet with a tab for each staff member that links their "work in progress" so that partners and managers can easily see how much work each of the fifteen or so staff members have.
I can create fifteen different tabs and fifteen different files on the network and link =[Staff1.xlsx]Sheet1!$A$1:$G$25 =[Staff2.xlsx]Sheet1!$A$1:$G$25 =[Staff3.xlsx]Sheet1!$A$1:$G$25 and so on.
If I make a change to the layout of the work in progress sheet, I have to delete and copy the file fifteen times, then go back through and re-link fifteen tabs to fifteen workbooks in order to keep it uniform.
View 1 Replies
View Related
Nov 24, 2008
In the code below I am defining ranges in a sheet and then using an offset and a scrollbar linked to the offsets. Then I make a graph using the data so that I can use the scroll bars to move the linegraphy left or right to compare the data sets.
My problem comes when linking the values to the graph. I know I can do this by referring directly to the xls file, but as I have loads of different files I want to apply this to I would rather use an active workbook reference...however this does not seem to work. The current code referring to the sheets works but then I have to go into the graphs and change the source data to get them to operate off the scroll bars.
View 8 Replies
View Related
Jun 5, 2012
I have a question and wanted to know if it was possibe and if so how. I wanted to link cells from one workbook to another (Which I know how to do) the problem im having is the linking works but why doesnt the cell color chang like it is in the workbook im linking from? Example: If A1 has text (Me) with the cell being green then the linked workbook would only have the text (Me) and not the green cell.
View 4 Replies
View Related
Jan 10, 2014
I am trying to implement the idea of creating an application with two workbooks: a hidden code workbook (CodeWb) that holds all of the forms and macros, and a separate visible data workbook (DataWb) that uses the macros in CodeWb. The DataWb houses a little bit of VBA code to open the CodeWb, which then supplies the programming power to handle click events, etc., performed by the user in the DataWb.
I have advanced to the point of being able to open CodeWb from DataWb and trigger execution of a macro named "DataFileOpen" in CodeWb. This macro initializes things in DataWb and creates buttons there on a particular sheet, using the line:
Application.Run "CodeWb.xlsm!DataFileOpen"
So far so good. This works fine. My problem is that nothing happens when I click on the buttons created in DataWb, with their event handling code residing in CodeWb. Obviously, I'm missing something that maintains a connection between the two workbooks.
How can I use the code in CodeWb to handle all events occurring in DataWb?
View 2 Replies
View Related
Jul 27, 2006
how to link cells from one workbook to another and being able to update figures using the refresh (!) button?
View 6 Replies
View Related
Jun 30, 2009
I'm trying to go through a workbook and, based on some user inputs, hide certain sheets and charts (these charts are their own tab, i.e. a chart object). Here's a sample code I wrote for a dummy workbook I have. Unfortunately it doesn't work, I think because the loops are nested. However if I can figure out how to fix this code I can easily adapt it to my other real problem.
View 2 Replies
View Related
Mar 6, 2012
Im looking for a way to check all charts in a workbook, and resize them.
There are two charts per tab, and i would like the first one to sit on cell A1, and the second to start from a25.
So each chart about 25 rows, by 15 columns if possible.
View 4 Replies
View Related
Dec 23, 2007
I have a workbook that has 52 weeks representing all the weeks in the year for a trainning plan. I plug in various stats like heart rate, energy expended, power, time, ect. Then, some other fitness markers are calculated from these values. So i want to take the data from each week (each sheet) and plot it in a chart on another sheet dedicated to just charts. I'm not really sure if i should reference the different cells into the sheet then make a chart from those, or can i grab the data from the same cells in all 52 sheets at once?
View 9 Replies
View Related
Nov 30, 2012
I am currently working with a hidden sheetname "hide_template" which contains formula linking to another sheetname "rawdata" of same workbook.
In this "rawdata", the contents is updated from time to time.
The problem is when I open this workbook and update the entries in "rawdata", the formulas/results in "hide_template" is not updated and invalid (ie. #N/A, #VALUE..)
This is the overview of process that Im working with:
===> open workbook ===> paste new entries on "rawdata" ==> run a macro to copy range in the "hidden_template" to paste to new sheet of same workbook
I already have a working macro to copy range from the "hidden_template" which works as follows:
===> set to visible the "hidden_template" ===> copy range from "hidden_template" ===> paste to new sheet ===> set to hidden the "hidden_template"
View 1 Replies
View Related
