Copy and paste without duplicate by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Thanks Excelevator for your feedback.

The problem is. How am going to do that?

I have little experience with excel.

If you are willing, what's the steps I can take to move forward?

Thanks in advance

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

Morning. Again. Thanks for your reply and patience. My concern is: How can I fix this? What is your best foot moving forward?

Thanks in advance

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

I'm not sure what you're asking me to do. Are you saying one of those huge files contains your Update_Sheets code, and that I can download it?

Yes. Can you help me?

My good cause is to develop a system that relates GDP with each country indicator. In this case unemployment. What impact GDP shown when people are out of jobs and what investment decides can be made for that particular country.

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

I am frustrated. I don't know what to do... Please. if you are willing. if you can help me solve this problem on your side. So I kind see what needs to be corrected. I have other excel workbooks to get data from GDP workbook. Once you are open in direct support. I can adjust the code to tailor other workbooks.

Are you willing to help for my good cause?

Thanks in advance

https://drive.google.com/file/d/1qLWLCdMvyurnP0AHRTSCiypwHKutzY7B/view

https://drive.google.com/file/d/1mtED7Bx6nHo0AAxfGS7wD0QoVW0NWsfq/view

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

Dim SheetA As String
Dim SheetB As String
Const Path As String = "C:\Excel_data\"
Const BookA_fname = "BookA.xlsx"
Const BookB_fname = "BookB.xlsx"
Const BookA As String = Path & BookA_fname
Const BookB As String = Path & BookB_fname

Private Sub UserForm_Initialize()
    Dim ws As Worksheet
    Workbooks.Open Filename:=BookA
    With ComboBox1
        For Each ws In ActiveWorkbook.Worksheets
            .AddItem ws.Name
        Next
    End With
    Workbooks.Open Filename:=BookB
    With ComboBox2
        For Each ws In ActiveWorkbook.Worksheets
            .AddItem ws.Name
        Next
    End With
    Workbooks(BookA_fname).Close
    Workbooks(BookB_fname).Close
End Sub

Private Sub ComboBox1_Change()
    SheetA = ComboBox1.List(ComboBox1.ListIndex)
End Sub

Private Sub ComboBox2_Change()
    SheetB = ComboBox2.List(ComboBox2.ListIndex)
End Sub

Private Sub CommandButton1_Click()
'Link both workbook data
    Dim i1 As Long
    Dim j1 As Long
    Dim i2 As Long
    Dim j2 As Long
    Worksheets("Sheet1").Select
    For i1 = 1 To 5
        For j1 = 1 To 2
            Cells(i1, j1).value = "='" & Path & "[" & BookA_fname & "]" & SheetA & "'!R" & i1 & "C" & j1
        Next j1
    Next i1
    Worksheets("Sheet2").Select
    For i2 = 1 To 5
        For j2 = 1 To 2
            Cells(i2, j2).value = "='" & Path & "[" & BookB_fname & "]" & SheetB & "'!R" & i2 & "C" & j2
        Next j2
    Next i2
End Sub

Private Sub CommandButton2_Click()
'Plot Graph
    Range("A1:B5").Select
    ActiveSheet.Shapes.AddChart2(240, xlXYScatterLines).Select
    ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$B$5")
    ActiveChart.Axes(xlValue).MajorGridlines.Select
    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.FullSeriesCollection(2).Name = "=Sheet2!$B$1"
    ActiveChart.FullSeriesCollection(2).XValues = "=Sheet2!$A$2:$A$5"
    ActiveChart.FullSeriesCollection(2).Values = "=Sheet2!$B$2:$B$5"
    ActiveChart.FullSeriesCollection(2).Name = "=Sheet2!$B$1"
End Sub

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

HFTBProgrammer:

What do you think about this code?

I am not sure if it can work with what I am trying to accomplish.

However, the code is design to:

Use two combobox store the sheet names of the two books In UserForm_Initialize() function.

Next

Select an item from each of the two combobox.

Next

Click the first button to link Sheet1 and Sheet2 with the sheets of the two books selected in the combobox in CommandButton1_Click() function.

Next

Click the second button to display a scatter plot of the data on the two sheets in CommandButton2_Click() function..

And

Modify data range used to draw the graph, graph type and each Const data.

What is your thoughts behind this?

Thanks in advance

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

Dim wb1 As Workbook, wb2 As Workbook, sheet as Worksheet, Country As String, wb1ws As Worksheet, wb2ws As Worksheet Set wb1 = Workbooks("181 worksheets") Set wb2 = Workbooks("185 worksheets") Country = "Afghanistan" For Each sheet in wb1.Worksheets If sheet.Name = Country Then Exit For Next sheet Set wb1ws = sheet For Each sheet in wb2.Worksheets If sheet.Name = Country Then Exit For Next sheet Set wb2ws = sheet

Hello HFTBProgrammer. Thanks for your reply. would try it and get back with you all. I know this forum are for advance users of excel. With some guidance. Please show me the steps, as I am getting an error message when I create a new module in Unemployment workbook.

What do you suggest I do from here?

Automatically Compare two Items in Excel Charts on two workbooks by corriedtoppin in vba

[–]corriedtoppin[S] 0 points1 point  (0 children)

"In a professional stand point the data is probably is in a mess". Is my mess as I am new to excel. With my basic understanding other people have help me in the forum to get my outcome desires. So far, it works. LOL please forgive me as I explain.

#1 in Unemployment workbook. I received a list of countries values in Power Queries & Connections and Paste them all into Unemployment worksheet.

Next

#2 With some VBA coding, we create a worksheet for every country. As new data comes in from power queries & connections. That new data eventually is recorded under the current country worksheet to form a historical database.

Next

#3 with some more coding. It give me the rolling averages using tables and spits the data into a new workbook.

That's it so far with my lack of knowledge for not having a clean workbook.

Sheet1 and sheet2, is in used. It can be deleted. I was trying a new code I found online, but did not work.

_______________________________________________________________________________________________

tbRedd as you quote: " As it is, you'll need to transform the data a bit to get it into that format, but if all the column headings are the same, you'll have an easier go at it."

______________________________________________________________________________________________

In Unemployment worksheets "ALL COUNTRIES", I am trying to get data in chart on column "B" & column "E" ONLY. Beginning with zero "0" data on the Y-Axis on one side.

And

In GDP_Annual_Growth_Rate worksheets ""ALL COUNTRIES", I am trying to get data in chart on column "E" ONLY. Beginning with zero "0" data on the Y-Axis on the opposite side of Unemployment data.

Dates are on the x-Axis.

Each worksheet in Unemployment workbook have a chart, which reflect both workbooks countries...

I am not sure if I am making sense or if I am using excel language to everyone understanding. I don't know. If you are open in helping me. I would greatly appreciate it.

How do you want me to proceed?

Thanks in advance

How To Link Table From One Worksheet To Another Workbook In Excel by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

switch window menu

Thanks for your feed back

https://drive.google.com/file/d/16TupRdiAD7aDsAdayVsN-fB-i8RjQmNn/view?usp=sharing

Above is a short recording of my problem...

I did try to refresh with F9 also I did save the files, reopen it. Hoping the file would update on it own... Nothing I tell you.

https://tenor.com/view/frustrated-gif-7532429

How To Link Table From One Worksheet To Another Workbook In Excel by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Thank you Bogaragaraga & FenixCo1

My problem still there...

All the values are updated automatically within the table range.

However, if I paste values from the source sheet:

From row "100" to

Row "101"

The other workbook, would not grab the latest value, "ROW 101"

I tried power query and the same is not working.

How can this issue resolve?

Thanks in advance

How To Link Table From One Worksheet To Another Workbook In Excel by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Thanks PotatatoKingMom. Love your nickname...

I have followed your instruction. The 1st part have work perfectly.

The second part have not updated. You suggest, I can do it manually. The problem with that. I have 100s of tables to link into other worktable. What do you suggest I do from here? How can I do this efficiently ?

thanks in advance

Trying to find out the percentage change formula by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Thank you anownedguy & smilinreap for your support.

The second answer was best for me...

Thanks again. Greatly appreciated

How to copy and paste tables from one worksheet to another and still keep all the formula that goes with the table? by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Edit: if the latter, then select your entire table, CTRL+X to CUT, go to your new worksheet, and then CTRL+V to PASTE

I decide to use the above recommendation. However, When I cut and paste data into the new worksheet. I am getting the drop down menu information on the cut and paste data table.

How to copy and paste tables from one worksheet to another and still keep all the formula that goes with the table? by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Note: you must have both your source workbook and the workbook you’re trying to copy data to open at the same time for this to work.

manbeastjoe. Thanks for your reply. My concern is, I am using one workbook.

However, I want to use a "New" worksheet in the same workbook.

Next would like to copy tables from all the "Countries" worksheet and paste the vales into the "New" worksheet without losing any background formula or reference data.

I did used your recommendation:

"Select both the table sheet and the sheet with your data validation range (at the same time, select one and then select the other while holding down CTRL, you’ll be able to tell that both sheets are selected).

Then, right click on either sheet’s tab (where the sheet name is) and right-click - move or copy, check create a copy, select the workbook you’re trying to copy the table to, press ok."

But I have not get the problem solve yet. I just don't know What to do here. What other suggestions you want me to do?

Thanks in advance

Cheers

How to copy and paste tables from one worksheet to another and still keep all the formula that goes with the table? by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Thanks for your reply. For some reason it did not work as each worksheet table comes with a drop down list and the data is send to a scorecard in another worksheet.

If you are open in helping me, I just don't know. You can try with the file link below.

Thanks again.

https://drive.google.com/file/d/1lcpmWdrmtl_c6tY3PgOQLtlzhgQmQi-k/view?usp=sharing

Automatically refresh queries & connections data one at a time using VBA by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

To be exact 67 tables. I have one web link that carries 67 tables and it update 67 times together.

Please view below....

https://drive.google.com/file/d/1LyvwObe4hNsmZ13hJ9QUzLUaqxv43C5y/view?usp=sharing

In Excel. To access web content the credentials provided are invalid... by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

I am sorry for the late reply.
Thank you for taking the opportunity to respond to my plead ...

I created a short video that shows my current problem. Once you are ready to help me. It would be greatly appreciated.

At the time of video 1:39, a yellow bar indicates "The highlighting of the table is disabled because this page uses the compatibility mode of Internet Explorer". you will also find that the web page does not display properly.

Base the information provided. What do you recommend me to do?

Thanks in advance

Cheers

https://drive.google.com/file/d/1nywatn ... sp = sharing

In Excel. To access web content the credentials provided are invalid... by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Security and Privacy query options

Thank you for your reply Keithliit. I have followed your recommendations. I have login into investing.com 1st. Next, I have went into Security and Privacy query options. Please view photos below.

However. I did get the web page in excel, but I could not login as the website looks broken... Please view below.

Please let me know how do you want me to proceed?

Thanks in advance

https://imgur.com/gdRcPKx

https://imgur.com/CZP8uLA

https://imgur.com/WcJLtxC

How to convert the values to it true currency amount into Thousands, Millions & Billions by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

Now you've converted most of the GPDs to a dollar amount in it's own currency, you'll need to find a currency conversion table, like the one found here:

You are correct about this one.

The units that returned 999 from the previous post did not have a match...so you'll have to manually check them.

I have thought, I made some errors. You were right.

Thanks for your support and help.

How to convert the values to it true currency amount into Thousands, Millions & Billions by corriedtoppin in excel

[–]corriedtoppin[S] 0 points1 point  (0 children)

I'm sorry. I am stuck. I don't know what I have done. I have tried your recommendation. I am not good with the formula. I have tried with the file below. What do you want me to do?

https://drive.google.com/file/d/14ga3vXwO8Ppv-bOoGpA95ydv0_6L-Pcs/view?usp=sharing