pull

Hello! Trying to get an index match, or whatever formula I need to get a sheet to work. Code currently pulls N/A. I'm trying to match the Heading Title then subtitle and finally pull the data around it. =INDEX(Data!C5:M40,MATCH(1,(Sheet1!E4=Data!C4:N4)*(Sheet1!A5=Data!A5:A31),0)) Here is...

I have a report that has over 1500 data points. On a separate ws, I want to pull in the top 10 values that are highest to least. how can I do this? Thanks

I have multiple sheets that I want to create a master tab. It needs to pull one cell value (J55) from each sheet. Not sure the easiest way to go about it. See example: column B,D,F,H....have to pull the day of month (each sheet is named for each day of month) Column C,E,G,I..... have to pull...

Guys I know that there is more than one way to skin a cat, but what is the best way to pull down data from more than 01 workbook taking into consideration the performance of the code? Pull data by a recordset? Pull data by Copying range Another Method/Approach? The codes below I developed...

Hi Guys I am creating a master spreadsheet and need some formula help. I am trying to pull through names of employees based on if they have a value against a project For example A,B,C are three projects on three seperate tabs. Person D,E,F are employees. Person D and F have logged time...

I am not sure if this is possible in Access or Excel for that matter... In my data I have a field Client PO. I am working on a project where I need to pull all line items associated with about 74 different PO #. There will potentially be additional lines of data added with these PO's. So I...

Hello, I am working with a spreadsheet that is split by Parts as you can see below. I need column A to pull revenue from columns F, H and I organised hierarchically by the date. So for example, cell A2 should contain "14/02/2019" because that is the earliest date and then B2 should...

Hi all, We get information sent to us in a text format and I'm looking to put this into a more manageable and easier to sort method. It is staffs shift pattern and is laid out as below. A1 = 9.30am to 5.30pm B1 = 5:00PM (B1 = commitment time) Ideally I would like A2 to pull out the start...

I'd like to pull data from another workbook. I'd like to open the folder that's named in A2. The user would then find the workbook and open it. I can populate the code for copying, but then i would want the workbook to close. Is opening and closing the workbook the quickest way to pull data?

Hi all, I'm back at it again and seeking help. I have created a power query in excel that combines and edits multiple csv files in a folder. The result is a table that looks like this, but has thousands of columns of data: I would like to pull out the coordinates from the rows and dump...

Hi all, I'm back at it again and seeking help. I have created a power query in excel that combines and edits multiple csv files in a folder. The result is a table that looks like this, but has thousands of columns of data: I would like to pull out the coordinates from the rows and dump...

i have the string " <colgroup><col width="571"></colgroup><tbody> Small Parcel Box Royal Mail Postal Box A4 310mm x 230mm x 150mm Diecut" I want to pull the text "310mm x 230mm x 150mm" i can use Find and Right to pull the first mm and extract specifc level of characters but im not sure...

I keep getting this error when performing a vlookup. No clue what I'm doing wrong. Here is the forumula: =VLOOKUP(B2,Salaries!B1:Q2000,16,FALSE) Trying to learn how to pull data from one sheet to another within the same workbook. Thank you!

I've been trying to pull apart a string into it's parts. I've sorted out some of it, but the last little bit is driving me crazy. Example CTH KGB01 3.171 (07) (SH) (Scooby Doo) I need to pull out the Scooby Doo part, and do it for thousands of different lines. The (SH) is not always there, so...

the code below basically takes information from the main page creates new sheets and pastes them into separate sheets depending on the content of A. it starts pasting them on row 6. it pastes them in the following order A into A B into B O into C how can I get it to go into the following...

Hello, Latest quandary. I need to set 3 conditions for a row of information to be chosen to have 8 columns copied and placed in another worksheet. This should pull only those records that match these three conditions from a worksheet with ~30,000 rows. Can anyone help me figure out how to set...

I would like to pull all the tabs in a worksheet to cells in a certain row. Thanks!!

Is it possible to use VLOOKUP to pull images from my table? If not VLOOKUP, is there a way?

Trying to figure out an array formula that would pull all data between 2 dates. Here is what I started with: {=INDEX(Loan_ID,MATCH(1,((Transfer_Dates>=Begin_Date)*(Transfer_Dates<=End_Date)),0))} But that only returned the top value. Then I tried...

How do I get a cell to pull in the tab or sheet name?