pull data

In excel, I am using this formula: =IFERROR(INDEX(Master!$G:$G,AGGREGATE(15,6,ROW(Master!$G$3:$G$98)/(Master!$H$3:$H$98=$A$13)/(Master!$I$3:$I$98=$B$6)/(Master!$J$3:$J$98=$A$4)/(ISNA(MATCH(Master!$G$3:$G$98,B$12:B12,0))),1)),"") The formula checks Master sheet and returns a value from column G...

Hi, I am using the following formula to pull names from another sheet that meet a certain criteria. It will only pull a name once, before moving onto the next match. However, for each name pulled, I want to add the word " Replacement" at the end of it. Is that possible? The formula I am using...

I have two sheets: Master sheet Supporting sheet I am trying to pull any names from column G in Master to column C in Supporting but only if the row meets the following requirements: The values in columns H, I and J in Master match the cells A11, B10 and A4 in Supporting. I only want it to pull...

Hi there, Here is my example, I got a chunk of data in sheet1 here, it's a task list contain start and end dates for each task. (it's comes from my calendar as power querry so it may fill up any times) ABCD1Start EndMy TaskPriority222/10/202225/10/2022Task 1LOW323/10/202224/10/2022Task...

Hi All, I really hope some genius can help me. Excel in Office 365. I have a spreadsheet that contains an array of data (column A-Q and row 2-10,000) The data that I have is generated from 34 sheets within the spreadsheet (I have converted each sheet into a table) and have been collated all...

Having watched a MrExcel YouTube video about pulling records based on a condition, I attempted to reorganise a large question bank we have for learners. Unfortunately, the formula doesn't seem to work as it's getting caught pulling correct row numbers and always returns 0...

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

I want the Columns from different sheet in the attached worksheet to be synced reciprocally. E.g. Sheet1 (CENTRAL) cell C8 is "producer", there is a similar cell in Sheet4(QC) C8 "producer", I want them all to be updated as soon as i enter data in Sheet1(CENTRAL). So that when I enter...

Hello! I am trying to pull data from another workbooks with the INDIRECT function. I have the following table in the main workbook: <tbody> File Value test1 B2 test2 B2 test3 B2 test4 B2 test5 B2 test6 B2 </tbody> I am using this VBA code based on another...

There is a CTR-CAR (Customer Transaction report / Customer accrual report) excel file that has a "CTR" Tab and a "CAR" tab. The CTR tab has a "Rebate No" column and often we have to pull a list of 10 or more rebate ID sections from the CAR report into a blank excel sheet to provide sufficient...

Hi everyone, i have two excel files say "mail-team1" and "mail-team2" Both are same and the cloumn headers like date, time, mail from, content, Action taken, target, remarks. Everytime a new mail comes, team1 will insert a row below the header and add the details (ie, recent mail is on top)...

Hi all, I was given a great piece of code the other day to help pull a range of data from several worksheets in a fixed location. This works great but now my boss has asked me to do something similar for another spreadsheet but this time the the source where I want to pull data from is...

Hi, I want to create a spreadsheet that will pull data from a form that my clients use. There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename) I want to copy the exact same cells from...

Good morning. I will try and explain this as thoroughly as possible. I have a sheet with Dates as rows and test locations as columns (just fyi...there are about 275 columns of testing points). It is conditionally formatted so anything out of control gets highlighted in red as seen on 6/5. Please...

Hi Guys, This is quite hard to explain (Bit of a noob) so bear with me. Basically, I have 3 sheets looking at each other, one for 3 different departments in the company I work for one for Purchasing, one for Warehouse & one for our accounts, using the "pull data" function in separate tabs, I...

Hello All Am Using Office 2013 Version Need Help To Create Macro To Pull Tile Dealers Name, Phone Number & Address Data From Web Site ( Justdial.com ) Example Pages From Mumbai City Tile Dealers in Mumbai, India | Justdial Tile Dealers in Mumbai, India | Justdial There Is Hundreds Of Pages For...

Good Morning. I am currently working on a tool, where I have a Macro in place to clean up and extract unnecessary data. What is left, I want to be able to pull key cell info and place it in a table on a separate sheet. - The data as well as cell location will not be the same each time - There...

Hi. This is my 1st post in a forum...so bear with me please. I need help! I need to pull data to a new workbook from a single cell in a range of sheets out of an existing workbook and divide it by another cell in that same range of sheets from that workbook. I have looked and the closest...

Hello. Looking for help in macro again. How I can auto fill with the positions and employee numbers once name field is selected ? File on google drive

OK so here's what i would like to do, and google just hurts my brain so I am going here for the experts, I need to press a button, have excel go into another workbook, which I will update each day with new entries, and pull out the data from that work book and paste it into my current workbook...