data acquisition

I need to write data to a text file as a data steam I have written preliminary code to capute data in a spreadsheet but the ultimate goal is to write the data direct to a text file without using a spreadsheet. currently the spreadsheet is just to verify that the data is being captured correctly...

I have an Excel workbook and an MS Word document that contain email correspondence content. The Word document contains information that is present in 3 basic lines as follows: The first line contains an expression that includes a link code, a sent date, and a received time. This will be apparent...

Hello friends, I want to extract specific data (Table) from this website ( https://www.nseindia.com/option-chain ). I am attaching a photo for clarification. Pls help me it urgent. Thanks

Hey everyone, I'm pretty new to Power Query and am having some trouble when it comes to loading times. When I refresh all data in the workbook (which is just the queries) it takes 7 minutes (I got a little frustrated and actually timed it haha) for everything to load and for me to be able to...

Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...

Hello. Looking for a solution to the below. I basically have a user-input file where the ID that the user enters should retrieve 3 pieces of data relevant to that ID with a VLOOKUP. The problem is that the data source is very large. I've put all the data on one excel tab, thinking that would...

I want to import ,say, D column from .xls (not csv) file, data is range, not table. How to do that ? I found how to import named column, but not basic

Hello, A forum contributer helped me create a dynamic array for 2 comboboxs which works great. Now I would like to understand how to either create a third combobox or set of third comboboxs based on the selection in box 2? Presently the first row of all columns is the title with the data below...

Hello, I have used some code from the net to create a dynamic data range for selection from the combo box. It all works well except one column. The column title displays in the first combo-box but the range does not display in the second? It is called the exact same way as all the rest and i...

Hello, I have a workbook which has a named ranged which contains the full path to a number of Excel workbooks. I'm trying to put a macro together that can pull data (either by opening in each of the files in the background, copying and pasting and then closing the file OR using the OLEBD or...

Dear All, I have file with 3 sheets 1. TE Deliverables 2. Job Cards 3. Processes In all the sheets, data is filled against activity VS date Vs employee the activity lists is in rows whereas the dates are in column and under each date there are 3 staff. so basically same date is repeated in 3...

I would like to set up a workbook so that I can retrieve the front pages of various news websites, and am curious what the quickest way to do that would be, if it is possible. As a pilot run, I have been using the Data tab to try and retrieve the headlines from www.cnn.com, and have not had...

Dear MrExcel community, I have a problem where I am trying to extract values from a dynamic (i.e. input are likely to change) worksheet to specific charts. Now, the dynamic worksheet is my "Data Input" worksheet and I have several chart plots depending on this. What I need, is a smart way to...

I am trying to get data from a website into a table in Excel. I am just using the regular button (get data - from web) in Excel (No code) Works fine for two websites but for a different website I am getting the following error: Details: "The remote server return an HTTP status code '404' when...

Hi, If I had two dates from 1/15/2018 to 7/10/2018 and I Had sales per day from historical data : Qtr1 - 20 - per day Qtr2 - 25 - per day Qtr3 - 18 - per day Qtr4 - 32 - per day I wanna know how much I'll sold based on this data per quarter like this : from 1/15 to 3/31 how many working days...

Hey, I'm a beginner at excel but I was tasked with refurbishing our budget template. It's a construction company and in the budget we describe what we're doing and what materials we use and price it by units, square meters etc.. The thing is we use a lot of materials, and looking them up by...

Hello MrExcel community! I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff...

Hi, I am creating a summary of temperatures logged every hour for three years at several different locations. I am summarizing by the hour (row headings) and location (column headings). The problem is, some locations only logged temperatures every two hours, while some logged every hour. When I...

Hi guys, I have a machine that is spitting out torque data that I am transferring into excel. I decided to filter it so that I am not overwhelmed with data that I do not require (no torque / 0 values). The data is also converted into inch lbs from NM. New data is added to the top row of the...

I have a worksheet setup to record household expenses and income (on a daily basis) and provide reporting at the same time. In part of the worksheet I record the daily expenses and income with totals at the bottom. I have very basic formula which adds up the daily amounts and gives a total for...