-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
read data
-
W
Read/import online weather data into an excel sheet.
He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...- wilco02
- Thread
- Replies: 0
- Forum: Excel Questions
-
T
Open a workbook and copy the first sheet into a defined sheet in excel vba
Hi, I am trying to write some code to load a sheet from another excel workbook into excel. But although I can open the file, I get a 400 error and the sheet does not copy. Code: Application.ScreenUpdating = False Dim MyFile As String MyFile = Application.GetOpenFilename()...- tmd63
- Thread
- Replies: 4
- Forum: Excel Questions
-
J
Read the data from a text file and reshape the data
I have a data set for different time intervals. The data has three comment lines before data for each time interval. For each time interval there are 500 data points. I want to change the dataset such that I have the following format: <code style="margin: 0px; padding: 0px; border: 0px...- jdbaba
- Thread
- Replies: 4
- Forum: Excel Questions
-
S
Macro/VBA to Read ASC file
Hello, I have been using Excel for a long time now, but I am just starting to learn the benefits of macros/VBA and I am loving it. I was hoping someone could help me with the code to import a .asc file into a workbook. I would like to create a button that the user clicks that asks them what...- SAFD1450
- Thread
- Replies: 7
- Forum: Excel Questions
-
L
Need to create worksheet based on data in another worksheet
I need to create an ownership report that reports data from another worksheet. The first thing that needs to happen is that the macro needs to ask which worksheet to read from, then it needs to ask which worksheet to place the data into. Once that is established, the macro would read the...- landman08
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...