pull

I don't understand why it does that, I have a userform which inputs invoices into a table when I try to enter the invoice number (for example, 312650370010022819) it enters a changed number to the cell! (changes the example to 312650370010022000) Then I also have a feature in the initilize...

Hello Everyone, I am having an issue with a code that I am using to pull data from an MS Access Database into Excel based on a date range. The issue is that it is pulling the data through, but it seems to be using the MM-DD-YYYY format to pull information when it within the low date range, but...

Hi- I would like to pull the amount from the chart, but to the next highest number. When I go to pull like 3390 it pulls the 3300 amount, I need the 3400 amount- Any ideas, thanks <tbody> Date: Reading Usage Chart amount <gwmw class="ginger-module-highlighter-mistake-type-1"...

The attached is a game schedule for a pool league. I'm trying to pull the data from the Game Table to the Team Table to the corresponding matches. Eg. If i want to pull in the opponent From Game 1 on 4/11(7 vs 3) and put the opponent 3 under 7 and also put opponent 7 under 3 <tbody> Date...

I have 4 invoices across multiple sheets (new sheet added monthly) and I want to create a master sheet with all part numbers on it. So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the...

Hi there everyone I have a spreadsheet that has each month of the year as a column and each of our products as a row. I need to use SQL data queries to pull through the total amount of sales per product each month. I have the SQL script for each month/product, but I'm unsure of the best way to...

I'm setting up a Data Connection to pull a bunch of stock option data into Excel, but when it launches the Excel browser and I navigate to the desired page to select the data table, I get a series of around 10 "Script Errors" (This is URL, you can try it yourself). Each error box asks me if I...

Hello, I have a formula in front of me that I'm completely stuck on. I need to pull a sum from a raw data sheet in another tab and I need it to only pull #'s with specific criteria from the same columns. Here is what I have so far...

Hello, I need a formula t pull the Number and Charters for example: "SSRG POLYL P400E HCG DRST210kg" I want only the 210KG pulled or if its LB 210LB :) Thank you!

Say I have the following formula in cell A1: "=100+500" how do I pull that 500 from the formula and put it in B1 using a formula?

Trying to pull the Manufacturing cost index from an XML pull. The XML comes from https://api.eve-industry.org/system-cost-index.xml?name=Osmon I successfully used the WEBSERVICE function in excel to create and pull the data; <CODE>B2 = Above Link, C2 = System name (i.e. Osmon)</CODE><CODE>...

I have a rent tracking spreadsheet for my tenants. I have a column showing each month their rent due or paid. currently, this is the formula I use to pull each months rent from the list of received rents: =SUMIFS('Rent Rec'!$C:$C,'Rent Rec'!$A:$A,'Rent Rolls'!$C4,'Rent Rec'!$B:$B,">="&'Rent...

Hi Everyone, I have a Document and I need to pull in data from other documents? So I want a macro that when I run it does the following, Opens All xlsx file in the folder my document is saved in that start with the word "Date_" and pull them into my document into one sheet. but there are a...

Here's what I need to do: I have a workbook (destination) that needs to open the latest version of a file (source) in a specified directory and pull certain fields from a lead sheet and place them in the destination workbook. - the directory will only store versions the source file - the source...

Hi I'm trying to pull data from many sheets to a sheet called "Catalog", but I'm not getting the results I want. I'm currently using this...

I am currently using the below array formula to pull information from another sheet. I want to add an if statement to this to only pull the data if Type equals "Employee". I have already done this with the other cells that are not arrays but cannot figure out how to make it work with this...

I am trying to pull the following HTML information from the following webpage (and would hope to duplicate this effort to pull all of the prices on the page): https://www.ebay.com/sch/i.html?_from=R40&_nkw=ralph+lauren&_sacat=1059&LH_TitleDesc=0&_dmd=1&rt=nc How would I do this? I have the...

I hve ts in cell B3 and B4.I need to pull the return in like this a I drag down. If I rag this down holding both cells it will go to =data!d10 =data!d10. I need it to go to =data!d9 =data!d9 and so on 10 11 12. Ned to pull in 2 cells at a time. Any help thanks =data!d8 =data!d8

I am attempting to use INDEX and MATCH to pull one value 'Material Description' from worksheet 'ZFGI04' based on 2 criteria from columns in worksheet 'SHIP REPORT - Test' (FCID and Product) I continue to get 'N/A' I am able to pull one value by using a based VLOOKUP so I assume it isn't simple...

I realize many I'm might be behind the times here, but this query use to run, but not now. I'm trying to pull some data from a query in an Access database, but get a debug on DAO.Database. From some reading, DAO is ancient and should be using instead ADO. I looked thru the References and...