1. Jyggalag

    Change order when pulling cells horizontally or vertically

    Hey guys, I currently have a large list of data, but to simplify, here's a simple example: I currently wrote cell C5 as = J5 I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5 However, I want it to...
  2. S

    how to get a worksheet to update without opening another workbook and without using vba

    Hi All, I have a workbook that pulls data from another workbook. At present both workbooks have to be open for the data to pull through. What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open. I cannot use vba as I also have another workbook...
  3. P

    Formula to pull values related to a coloured cell

    I have 3 cells, each cell has a value, 1, 2, 3 The cell value is related to a score, each score located in another cell, 10, 8, 0 To pick a value, the user has to change the cell colour, for example the user picks the cell with 1 and shades it any colour Then the formula needs to pull in the...
  4. C

    Pull through data from table based on oldest date

    Hi all, I have a three column table, one column with a name, another with a date/time timestamp, and a third is whether that row is completed. I basically need to pull through a name to another sheet, but it has to be the oldest uncompleted. I just can't suss how to do it! Someone has...
  5. S

    Need help with a Match / Vlookup type formula

    I have this data, it has too much details in one column. I'm trying to write a formula that will find only certain contents based on cell A on another tab. If it matches whats in one of those cells, then pull that name or details. How would I go about writing a formula for this? I looked up...
  6. H

    Need Help with Formula / Skipping Lines

    Hello, I am trying to create a sheet in Excel to pull Hours from another sheet to upload into a system as a CSV file. I need a formula for hours that would pull in the Reg Hours and then say if the Overtime cell has a value then it will make a second line for that same employee and pull in those...
  7. D

    How to return a specific serial number when a user has multiple assigned in their name.

    I currently have 2 sheets of serial numbers sheet 1 has all of the new serial numbers on it and sheet 2 has both old and new serial numbers on. I am currently trying to bring all of the old serial numbers into the sheet 1 but due to the nature of index match and vlookup I am only able to pull in...
  8. H

    TYD Data from Monthly Data Input

    I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
  9. B

    Finding cell data when condition is true

    I have two different spread sheets with categories and I want to pull the category ID of sheet B into sheet A. While they have similar names they are not identical so I cannot do a simple VLOOKUP or other similar method. What I want to do is search if any part of the category name in sheet A is...
  10. reneev

    Pull info from First Column with Data

    I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...
  11. Q

    Sumifs returns 0 value for alphanumeric sumrange

    Hello All, So my data from where i want to pull the sum range contains alphanumeric values in like "GS08, GS09, GS10" The criteria1 range is the range for unique client reference nos. in cells A2:A2688. Criteria1 is to pull each inidividual client reference no. for eg. 64852345. Criteria...
  12. T

    If Lookup?

    I have one file with two sheets. One sheet one in row one I have one column as name, column two as a number and column three as a month of the year. On my sheet two I have the same three columns. How can I pull just a single month (like Jan) from the sheet one to sheet two? Doing this using a...
  13. T

    Wildcard for MSQuery not Working

    I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent
  14. D

    Help Needed!!

    Hi All, Hoping there's an easy formula for this as I am having a blank moment. So the below is a simple example of what I am trying to pull through in to column E. I would like to look up multiple "Item Number" which are the same, sometimes theres 2/3/4 of the same items. I would then like...
  15. D

    advanced filtering vba picks up wild cards?

    so i have in column A...booking point...and under that...x376x, x324x.... in column B, i have product type....under that, TR Swap for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i...
  16. B

    Email VBA pull email address from cell

    Hello all, I have this simple VBA to send the sheet as an email when a button is pressed. Sub MailTest() ActiveWorkbook.SendMail "email@email.com", "Leader Standard Work for previous week " & Date End Sub How would I change this to pull the email address from cell A10 on tab "Directions"...
  17. L

    Vlookup OR Index/Match function with multiple criteria

    <tbody> Employee Name Employee ID Position # Position Status Employee A 111111111 111111 A Employee A 111111111 777777 W Employee B 222222222 222222 A Employee C 333333333 333333 A Employee D 444444444 444444 W Employee D 444444444 555555 A </tbody> Hello there...
  18. S

    Dynamic SumIf or Index Match-Match?

    Hello, I am looking to pull values from an assortment of invoice formats that will populate a summary sheet (example below). Though location of "Fund" and "Amount" can vary within each invoice (and they don't always begin on row 1), they always contain the same headers. Is there a way to...
  19. A

    SAP / Excel Analysis

    Hello, I'm using the Analysis tab to pull things from SAP BI - for whatever reason if it goes over a certain number of records, it either disconnects me from SAP Business Objects, or gives me a "no data" message. What I'm trying to do: I'm trying to pull all orders for all accounts, so I can...
  20. J

    http elements xml

    Hello, Getting confused with Div tags etc. Any guide for this? How do you pull a "$0" from html in VBA via XML? Thanks.

Watch MrExcel Video

This Week's Hot Topics

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