pulls

  1. MFish

    Able to individually pull data out of a table, along with the full amount?

    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...
  2. S

    Lookup and retriving more than 1 line

    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...
  3. M

    vlookup from a user form?

    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...
  4. J

    Indirect Function Causing #Ref! Error

    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...
  5. I

    Stuck on Basics - Making XY Chart from YX Data

    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...
  6. J

    Index-Indirect-Match Formula Only Pulls First Match

    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...
  7. Guzzlr

    Sum If Is Not Summing Horizontally

    =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
  8. C

    extracting info

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

    VBA AutoFilter with Hyperlink

    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...
  10. J

    VBA: How to Scrape this URL in Excel 2016?

    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...
  11. E

    Need Formula to pull the content on a cell

    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>
  12. N

    New data list that removes blank entries

    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...
  13. S

    Looking to sumif data from month 1 to N

    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...
  14. H

    duplicating multiple columns automatically (yearly info)

    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...
  15. 1

    Splash Screen while calculating?

    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...
  16. 1

    Macro to prevent macros from running until certain time

    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...
  17. K

    Need help with an INDEX function

    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...
  18. D

    Pull cell formatting from a master sheet to other sheets

    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...
  19. C

    Type in a name and it lists their manager.

    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. :)
  20. D

    Vlookup not displaying dates

    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?

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top