import data

  1. R

    Macro to refresh workbook, clear sheet, refer to path and import columns

    Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...

    Automatically importing data into Excel

    Hi guys. Okay, so I have a potentially really tricky one here... I have a design software, in which I can export a design to an item list in either a standard .txt Text document, or an overly detailed XML Document. Whilst the software allows me to specify what information to export to the .txt...
  3. H

    Import data from other files

    hi I have some code which has been working really well importing data from other files into a central file. Here is the code...
  4. S

    Is it possible to take a list of numbers and put each one of them in a different cell

    Hi, I have a lot of data sequences I need to statistically analyze. The problem is that the numbers are separated by a space character. I need each number to be in a different excel cell. Is there a way to tell excel to use the space as "move the next number to a different cell"? For example...
  5. B

    PowerPivot - Import data and append new data on a daily basis

    Hey Guys (and Gals), I currently have a daily report that imports data (in table form) from a file that is placed into network folder every morning (I did this using Powerquery). So, everyday I go into my report, hit refresh, and the table is automatically updated from the file sitting on the...
  6. D

    Import Most Recently updated rows

    Hi All, I have a SOURCE workbook I use for Order Management and when I submit the form data to the sheet, it also submits it to a closed, HUB workbook on a shared drive. There are 6 other people using this. The HUB workbook has everyone's work. When you open the SOURCE workbook it will ask you...
  7. A

    Macro slow with shapes; Sheets with shapes not touched

    Hello I'm using this board quite a few times but I never posted a question. I'm working on a special project in my company and for this project we use excel and vba code. We got a strange behavior. With VBA we import data from other workbooks into the main workbook. This tooks about 30s for...
  8. N

    Control part of SQL Query inside External Data Connection from within Excel Workbook.

    Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. As part of the Advanced Options while creating that connection I included a SQL query that basically reads: SELECT...
  9. N

    Excel connected to SQL Server - every new import causes REF! errors and issues with formulas

    Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. When I built the file, I imported the latest information from the SQL table, which created a table automatically in Excel, and then...
  10. S

    Import data from spreedsheet with multiple web links

    Hello, Trying to import data from a website.( I have a spreadsheet with multiple links to specific products.( ex. How an I make Excel click on the link from spreadsheet, copy data from website( price...
  11. G

    Excel equivalent to Google Sheets' "importdata" function?

    Hello, I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example Is there an Excel equivalent? I tried getting...
  12. B

    Import automatically data from 2 workbooks and keep source formatting

    Hello there, I have a folder containing 3 files : my Excel file (with my macro), Book1 and Book2. I would like to create a macro to import automatically my two ".xlsx" files (Book1 and Book2) in my Excel file. Data from Book1.xlsx would be placed in Sheet1 and Book2.xlsx in Sheet2. I also want...
  13. L

    Importing multiple XML files to excel

    Hi I'm having trouble importing multiple XML files to excel at once. Does anyone know if this is possible? I have been able to import one file at a time (however, this is importing the one file ~15 times) but not multiple XML files at once. I have been using the following procedure: Data >...
  14. G

    Importing data from multiple pages of a single website

    Hi all, I am new to VBA and have been facing a lot of trouble with figuring out how to pull data from the website I am trying to extract weekly data for the years 2010-2015. So i found a code that did something along the same lines and changed it to suit my needs. It is as...
  15. V

    Delete First & Last Line of Imported Data

    Hi All, I am importing some data from a .txt file but the import data's first and last lines are un-important headers and totals which get in the way of how I am using the data. Other than having to manually delete them on each refresh what is the easiest way of automatically deleting them on...
  16. E

    import data- query

    hey guys: i was trying to import data from internet to an excel spreadsheet by using the command query. With Sheets(1).QueryTables.Add(Connection:="URL;" & miurl, Destination:=Sheets(1).Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = False...
  17. L

    Open hyperlinks from Worksheet and import their data

    Hi, I have a worksheet with a series of clickable hyperlinks to a webpage with the information I am after. Is there some code to loop through each hyperlink and import the data from the webpage that it opens? All my Hyperlinks are in column B however some cells are blank so I would like the...
  18. S

    Large Excel

    hi, I currently have a growing excel sheet. I copy/paste daily information and use it to feed into multiple pivot tables. My concern is that the spreadsheet is growing and constantly causing issues. I have to do a lot just to maintain the spreadsheet. At this moment we cannot import data from...
  19. J

    How to import owners info from pinellas county property appraiser to excel.

    I have 2612 addresses and need to import the owners address into the excel file.Trying to do it one by one is hard.Please help if you can.Here is the website to find the info and the example of the addresses i am using. Pinellas County Property Appraiser a few addresses and the columns they...
  20. M

    Export data from Java to Excel

    Hello guys! Could you please give me any tips on how to extract the data on this site Market data | Nord Pool Spot to excel 2010? The table is dynamic and updates every hour so I want the new data be imported to excel aswell. many thanks Mikael

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back