bring

Hi Everyone, I am looking for a formula to bring in the first two values in a row. Here is my data set: My desired outcome is the inventory during request 1 and 2 <tbody> Inventory during request 1 Inventory during request 2 12/8/2018 12/9/2018 12/10/2018 12/11/2018 12/12/2018 12/13/2018...

Hi Everyone, I am looking for a formula to bring back the column header for the first value in a cell. Here is an example: <tbody> Customer 12/17/2018 12/18/2018 12/19/2018 12/20/2018 12/21/2018 Customer A 800 800 800 515 </tbody> My goal is to bring back 12/18 since it...

Good Afternoon Everyone, I have a table that I am trying to bring in values based upon a pivot table I created. My goal is to bring in the values for a specified date. My table is set up from the current day and out. I am struggling using get pivot data because my column of dates is a formula...

Dear Friends, A: I have a worksheet of " Offshore Weekly Crew Change of Staff". I have all names (40 Names) in the left most column with validated (Drop down list). I need an Excel function to take any value from the left side validated drop down value and bring the corresponding ROW vales at...

Hey all, I have a workbook which contains multiple sheets for users. And each sheet contains users comments or no comment at all. I want to bring all the comments (if there is any) to a specific sheet. Here is an example file. https://ufile.io/0arac I want comments of all sheets named...

Morning folks I have a spreadsheet that has a column with peoples job titles in. Examples of how the data looks is as follows: HSCB*002*IRB Board Member*Contract* HSCC**Commissioning Manager*CS* In another column I would like to bring through the job title that can be found after the second...

Hello... I'm using Excel 2010 and I have an issue with some pictures. I load some pictures with the below code and I want to remove a specific one or bring in front the other one. The problem is that any time I load a picture the excel name is different and I dont know a way to find that name to...

I need you to help me complete a macro, I want to pass a data from the macro to the linked page and then bring the information back to the macro.

I have one spreadsheet that has Last Name, First Name in one cell. I have another spreadsheet where I have ID#, Last Name, Middle Initial, First Name each in separate cells. I would like to use INDEX and MATCH formulas to bring over ID# to the first spreadsheet. Is this possible? Thanks!

Hello Excel Gurus, I am running the following code to do a simple task which is to bring all the sheets in the Workbooksheet to Position A1 and if there are scroll in the other sheet bring them to original scroll position with Columns like A... B...C ....D....E... etc etc. I am getting the...

Hi All, I need to fill this 3rd party template and is there a way i could bring only the required in for. For eg: i have 200 product codes in a separate excel sheet and i only need to bring 100 product codes to the template. in the original 200 list i have column say whether to publish or not...

Hello I am using the following formula to bring back the amount paid from the payment tab to the data tab. My problem is when there are two payments it brings back the earliest payment not the most current payment. For example if a payment was made on 05/15/18 and 06/05/18 I would like it to...

Hello, Hoping someone can help me understand the logic in this formula...what cells is it referencing? If I want to move the information from one column to another how would I get it to reference this column instead. =IF(A2="SHOES",AC2,IF(A2="Lucky...

I was using the small function until I got stuck. Is there a way I can match the name to a value when there are duplicates? For example, in the chart below, I would like to order these from smallest to largest and then bring in the name next to it also. Since I have two names with $1 how do I...

Hello, I am trying to do a sheet where i look up data and bring back a total. I have 2 spreadsheets 1 with the data and 1 as a front sheet. I need the front sheet to look at the data and bring back the total. This is the data sheet <colgroup><col><col><col span="4"></colgroup><tbody>...

I have a userform and when I click on a button, it opens a new workbook, but the workbook is behind the userform. I want to bring the new workbook to the front, without having to hide the userform, so when the person is exits the new orkbook, the userform is still there for use. Thanks Mike

Hi, I created a dashboard for work and a part of the screen it allows you to select different charts (Top location breakdown, custmer breakdow etc.. Basically when criterai in cell is select it will bring that chart/analysis to the front of the area. They asked if I could add Key stats option...

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> #DIV/0! </tbody> Morning All, I have a number of different formulas within a work book which look at a data set which sometimes shows zero's or no information, So as you would expect...

I have a workbook that I use to track attendance for meetings, training's and a few specific duties. I have a worksheet for each individual I track where I put the totals each month. I have another sheet that references each individual sheet to give me a good overall view for all individuals...

hello please help i have 4 columns and there words in them. i want a code to bring same rows in column C with B to side bye side same row with moving C and D rows together. so i want to see same words in C next to same words in B but code must move C words with its meaning in D. others that not...