relevant

Hello.. I am trying to get a formula so that when A1 matches a Product ID in Sheet2,Column B, it will a) return the data from the relevant row in Column D, if the corresponding row in column Q = No or, b) return the data from the relevant row in Column R, if the corresponding row in column Q =...

Hello all- Trying to cross reference one worksheet with another(old format) and return the relevant data that is in the left column if they match. HELP

Hi all, So I have a raw data table on one tab in a worksheet. Its got about 30,000 rows - Column 1: 50 Unique values (US States) - Column 2: X Unique values (Counties with those States) - Column 3: Short amount of text entered into a cell (I know, but its done now). I want to create 5...

i have an advanced filter, but so far there's no relevant data so after the advanced filter, only the header row shows up and the total row (ie the row after all the data) is blank. (currently the total row as of today is 24,000 but it can change daily depending on the day's data....again, the...

Hi, is it possible to create code to go through a table and if a value is met transfer the whole contents of the row into a new sheet totalling all relevant values. For example creating a sheet with all the row information for every row that has the value in Column F higher than 0? Thanks in...

Hi. Please see Excel spreadhseet via link. https://1drv.ms/x/s!AtIvkRgReIvwgQsRvSATK0IvdCRG Please can someone help me with this, as I have tried and tried to get it working, without success. In column AV I want to return the value relevant to the column AW. Column AW will return the...

I have a vlookup in col B, that looks at the 2nd column in the source data (ie Jan). That works fine. But I'd like to drag this vlookup to the right so that it looks at the relevant columns. At the moment if I drag my vlookup to the right it'll keep looking at the 2nd column. I'd like the...

Hello I have an excel spreadsheet which in column a2:a:60 have the names of the compressed folders to create. The files names to insert in to the relevant compressed folder are captured in columns B to M of the relevant row. Would anyone able to create the VBA code for this? Thanks C

Hi All. I'm new to the forums but am confident in excel and have a conundrum i'm hoping I can get some assistance with. I have a sheet containing transaction information (Sheet1) and a reference sheet (Sheet2) which lists items and price breaks. The number of price breaks is different per...

Hello Masters of Happiness, I have learned tons on this site without ever asking a question, but today I need help!! I have a protected worksheet, and users are to access certain cells. Those columns that are most relevant are displayed, while less relevant columns are grouped and collapsed. I...

Hi probably been asked 100,s of time but can't see what I'm looking for. Can you open a worksheet in excel & only show rows relevant to whats types into an "InputBOX" ie a number code. Also ensure nobody can view rows that are not relevant to themselves.

Hi, I have a workbook showing the jobs which consultants are being paid for in the latest payment run. This consists of a front sheet and then a sheet for each consultant. I'd like to run a macro which emails the relevant sheet as an attachment to the relevant recipient. I would imagine...

I have a spreadsheet that calculates costings. I want a start page or tab that allows you to enter costings for various dates, press a button and for it to filter the entries into the relevant sheet for each month depending on the date of the costing. I already have developed a spreadsheet that...

Hello! I have this function but it doesn't seem to work SUMIF($C$24:$DR$24,C$21>=TODAY()))) I want to sum the cells that belong in the range $C$24:$DR$24, and that the relevant row 21 cell above them, has a date that is later than today. Any idea? Thanks!

Hello everyone, I want to create a pivot table in which when I select a a value in Filter 1, Filter 2, 3 and so on, show only the values relevant to Filter 1 instead of the whole list. In other words, when a certain value is selected in Filter 1, the rest of the filters automatically show only...

Hi i am after a VBA code to look up the week selected in summary sheet B4, find the relevant worksheet in the workbook copy rows that match the criteria also selected in B5 Summary sheet . I need the relevant rows copying across to the summary sheet starting at A9

Afternoon all, I have been frustratingly searching around the internet for a solution to this, but to no avail… So am hoping that one of you kind souls may be able to help I have been creating a ‘Non Compliance form’ for my business to collect all relevant information in a consistent...

Hi all, I am trying to put together a report for school and need some help. In the attached spreadsheet, I have a summary tab and three tabs for Americas and Europe and JAPAC. For the summary tab, I need to pull in information from the three tabs (JAPAC, EMEA and Americas). For Columns C...

I have used the Index formula to pull information from another sheet within the same workbook, but it does not work properly. The 2 sheets are identical, and should populate the relevant information, but it isn't. Formula: =IFERROR(INDEX(Outstanding!I:I,MATCH(J2,Outstanding!J:J,0)),"") I am...

Hi First time here :) I'm building a calculator for my company which contains many products that have multiple options Was wondering if possible to make it on one page with drop list that will show only the group of cells that are relevant to the selection (some sort of iFrame - which can be...