pulls

Hi there, I have this code that's corresponding to a table that pulls the total amount but I'd like to know if there is a way to also make an additional table that you can "edit" or press a button/search bar to look for a person's name/employee # and it pulls just their data? My goal of this...

Hi everyone, I am trying to create a report that pulls through data with more that one line when a certain criteria is selected from a list. For example if I select a country I want it to pull through everything that is against that country. I tried a basic lookup but that only pulls through...

I have a user form that I would like to modify the code on, It has a list box that pulls up a part#, then it has a text box for the cost of that part. In the text box I would like to do a vlookup that refers to the list box and pulls in the cost from a table. Currently the text box has this...

The following formula pulls data from the specified workbook, even when the workbook isn't open: ='C:\Users\Username\Documents\Report\[Test Workbook - 6-11-2019.xlsx]Sheet1'!A1 I added an indirect reference to the formula and it pulls data from the workbook... the only problem is said workbook...

I may be too stupid to live. I would simply like to make an XY Scatter chart - where the X-Axis Data is in column C (header in C1), and the Y-Axis data is in column B (header in B1), and I'd like to label the points with the text in column A. I keep futzing with it, and I either get it...

I am trying to create a summary page that pulls data from different sheets that represent each year. It pulls the data based from cell S2 which is the fiscal year and uses indirect to pull from the corresponding tab name. It then looks up the sales location (B43) and matches with the title...

=SUMIF(B2:B4,B2,F2:J2) Hello All, I ran into an issue using SUMIF. The formula above only pulls the number in F2. I want the SUMIF to sum horizontally, instead of vertically. I thought it would sum horizontally? thanks

is there a macro that once an external file is open it pulls certain info from it and plugs it in to various sheets?

Hello all, So I have run into a snag on a file I have put together. I have added the following code into a module: Sub Filter(lField As Long, sCriteria As String) Worksheets("Shortage_Report").Range("C1").AutoFilter Field:=lField, _ Criteria1:=sCriteria End Sub And then on the...

I used to record a macro to scrape this url: "https://www.marketwatch.com/investing/stock/NVDA/options?countrycode=US&showAll=True" Two issues have happened since I upgraded to 2016. 1. The Query Editor says its unable to do so because of Internet Explorer Compatibility Mode 2. 2016 pulls in...

I have about ten columns with different type of expenses, on one of these columns there will be one expense category. I need a formula that pulls the value on that cell <tbody> Cleaning Supply Empty Cell Empty Cell Formula that pulls Cleaning Supply, the only cell with Value </tbody>

I have a list of numbers in column A containing duplicates, and a list of text values in column B. Some of the cells in column B are blank. I would like a formula that generates a new list (on a new workbook or tab) that only pulls through numbers from column A that have a value in column B...

Hello Misters/Misses, I'm trying to setup a table for some Year-to-Date data from a massive list. Would like to have a formula/vba that pulls different data and sum/count them from month 1 to N, in which N serves as an input. For example, user (my boss) input 4 as April, the table then pulls...

Every year I have 6 columns with formulas in 3 out of the 6 columns that duplicates every year. Is there a way to have this setup automatically repeated when I tab over to the next empty cell or will the formulas not reference the correct cells? EXAMPLE: I6 - Date, J6 Banked (formula pulls...

I am currently working a workbook that pulls data from a variety of sources. I am using a lot of lookups, which is slowing it down. That is a fix for another time. What I want is for while it is calculating processors, to have a splash screen. I have one currently, but it pulls up after the...

Longtime lurker, usually can find what I need but this is bothering me..... I have a report for work, that users pull data from. They click a button for the day of the week, and it pulls data from a report I upload, and gives them data for the previous day. However, many people are pulling it...

I need a formula that will take the data on sheet1 column C and have it appear in sheet2 row 4 (5 columns between) that works by copy&paste. For example: I need a formula for Sheet2 I4 that pulls the data from Sheet1 C3 OR another way to think of it send Sheet1 C3 to Sheet2 I4, C4 to N4, C5 to...

I am having trouble pulling the cell formatting from a master sheet to multiple sheets. My formula is as follows: ="your property to be, which for the "&MASTER!A1&" tax year is "&MASTER!K8&". This assessment represents a "&MASTER!Q8&"" when it pulls the 5,000,000 in cell K8, to the...

Hi, I'm trying to set up some function that will allow me to type in a colleague's name and it pulls up his or her manager. Appreciate any assistance in this. Thanks you. :)

Good morning I am not very familiar with vlookup....everything works on my formulas except for the one containing a date. Instead of pulling up a date, it pulls up a random number. Any ideas?