I am not sure if you can help me. I just don't know...
I would love to know, how to make comparison chart to display two varying sets of data.
I have two workbooks.
One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.
Next
The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.
This is the hard part:
#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.
#2 How can I create a comparison chart to display two varying sets of data, both varying sets of data beginning with the zero values?
If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.
In the example I showed, It put a link of A1:B5 of BookA to Sheet1 and a link of A1:B5 of BookB to Sheet2, and draw a scatter plot of them.
Change the variables i1 and i2, j1 and j2 of Private Sub CommandButton1_Click () and change the ange ("A1: B5") of Private Sub CommandButton2_Click () according to your environment.
In my environment I can't see the link you provided, so it may be an irrelevant answer.
First, prepare two excel sheets(Ex. sheet1 and sheet2).
prepare two combobox and two commandbutton in the userform.
The two combobox store the sheet names of the two books In UserForm_Initialize() function.
Select an item from each of the two combobox.
Click the first button to link Sheet1 and Sheet2 with the sheets of the two books selected in the combobox in CommandButton1_Click() function.
Click the second button to display a scatter plot of the data on the two sheets in CommandButton2_Click() function..
Modify data range used to draw the graph, graph type and each Const data for your envronment.
I am not sure if I can fix this. I am trying my best to follow your teaching. I am not sure what I have done is correct and it seems like I am not getting the results.
Please SioSio. If you are willing please let me know as I have place the codes in the files below.
It seems that the contents I wrote before did not reach you well, so I will show you the procedure again.
1. Create a "new" excel book.
2.Prepare two excel sheets(Ex.sheet1 and sheet2).
3.developter tab
Create a Developer tab for your convenience. To turn on the Developter tab, execute the following steps.
3.1. Right click anywhere on the ribbon, and then click Customize the Ribbon.
3.2.Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).
3.3.Check the Developer check box.
3.4.Click OK.
3.5. You can find the Developer tab next to the View tab.
4. Click "Visual Basic" on the Developer tab to open the vba editor.
5.Click Insert, "User form".If the Toolbox does not appear automatically, click View, Toolbox.
After this, create two comboboxes and two buttons according to the contents written earlier.
P.S.
The link you posted is not visible in my environment.
Please use the tools in "Post your reply".
Thanks for your feedback. I greatly appreciate it.
I have followed your second comments, but when it comes to the coding. I am not sure if I made a mistake. I have receive an error which states: "Compile error: Invalid qualifier".
Please view code and image for a better understanding.
In the example I showed, It put a link of A1:B5 of BookA to Sheet1 and a link of A1:B5 of BookB to Sheet2, and draw a scatter plot of them.
Change the variables i1 and i2, j1 and j2 of Private Sub CommandButton1_Click () and change the ange ("A1: B5") of Private Sub CommandButton2_Click () according to your environment.
SioSio. I must say to you again... Thank you for your patience and support.
I have followed your instructions and tuition. Please identify below if the code have been plugin into the right location and please view the screen shot of the error and other photos that supports what I am trying to accomplish.
Hi !
I'm new to asp. I have made a page to display a chart based on data from my
SQL-server. I have used Office Web-component graph. Here I can set the
correct SQL statement and the graph works...
Hi
I m facing strange problem...
I have one field char type data length 1..
It has data either 1 or 2 in all the field tht I have
checked through enterprise manager.
I'm running query
"select...
Walkthrough: Creating a Web Page to Display Access Database Data
I've started the above walkthrough. However, near the beginning it gives
the following instructions
To set permissions in the...
How do I make a report display the current record open in a form?
This seems like it should be a simple issue however I am strugling to figure out what code SQL / Querry I should use to do this....
Hi,
I've made a piece of VBA that uses a combination of combolists and listboxes to run a query. I just can't think of a way to make this query generate a chart based on its results.
Here is my...
..NET 3.5, Windows Forms app: My objective is to display parent/child data in
two ComboBox controls, such that when a parent item is selected in one combo
box, associated child items appear in the...
Hello All
I am using Microsoft Access 2003. I have an input form (Single Form) into which the clerk records appliance details. Some appliance details will never change, for instance the 'Make...
I'm trying to find out why the android browser won't load and/or display my XML data. This javascript works fine on computer browsers (FF, IE, Safari, Chrome, Opera) and even in iPhone's Safari, but...
Actually i have the two divs on left side div i will dispaly the subcategories.Then if we click on the any of the subcategory it should display the related data in right side div without page...
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...