located

I have data spread out over 17 columns and down 300 rows. I would like to retrieve the amounts from 2 cells relative to a cell that contains a specific number. I'm hoping you can help with a formula that will lookup the specific number 84001 and retrieve the amount that is located 3 rows below...

I have the following formula: =LOOKUP(2,1/(Test_Method=Report!A2),Re_Assment) how do not use name rang. test_method= column "A", Re_assment =column "H". the named column are located on a sheet called "Entry Sheet" also, I would like it to copy the cell format.

I would like to enter a formula in cell J4 of sheet2 that looks at G2:G3179 in sheet1 and finds the # "1090000" and then pulls the value associated with this # located in column M of sheet2 in the same row where "1090000" is found. I thank you in advance for your help.

Hello, what I want to do is: i have a ranged name" Adjusted" and ranged name " Start" which is located in A1. i want to delete entire columns between range "Start" and "Adjusted". wherever the range " Adjusted" is located. btw, before this code, need to find the range "Adjusted" and delete all...

I have a spreadsheet that details each employee's sales for each day. I currently use the following formula to calculate an employee's sales figues between 2 dates located in cells G5 & G6. Cell D6 contains a drop down list containing each employee's name. I'd like the exact same result but to...

Hello Everyone, I wish to use VBA to retrieve the folder (or path) in which a workbook is located. For example if the workbook is called "MyWorkbook.xlsx" and is located in "C:\ExcelWorkbooks\" (which means the path to the workbook is "C:\ExcelWorkbooks\MyWorkbook.xlsx"), I want the code to...

Good day I'm looking for help in programming a macro or a VBA to get filter the slicers for only the today date please a photo if the file with slicer and where the button will be located https://www.dropbox.com/sh/ax6g0k3w7kitkjd/AADrRks7V-jEykeGlqU89x6ta?dl=0

Using Excel 2000 Hi, My data are divided in the 4-parts (part-1 to part-4) in columns C:AC, within these columns in the each row is filled only one cell within any of 4-parts. I want the results in column AE:AH "part number2 in which part data are located Example data...

I was wondering if there was a way to create a marquee banner that has information like charts, announcements and documents with a continues scroll, and to see more details you can click on it the chart or announcement and it opens to where the data or information is located.

Hi People, I'm not sure if this problem will require more information, but to simplify, I have the following issue: When using data validation, and the following formula: =INDIRECT(A1) I get exactly the results I want. In A1 is the formula: =VLOOKUP(C12,tblINDEX,3,FALSE) This refers to a...

Good Day, How can I populate the datas into the listbox base on selected two comboxes. ComboBox1 datas located on column A "showing as months" ComboBox2 datas located on column B "showing as department names" Many Thanks

Estou adaptando o código abaixo e encontrei uma situação em que não posso extrair os dados. Na parte final do código, você indica onde o Loop é feito para encontrar o objeto da tabela e os objetos do Conjunto CEP estão localizados, se você está localizado, você indica a partir de qual objeto...

Hello all, I am looking for a solution for the following problem: I want to automatically merge data from several action lists into one big action list. In "C:\directory 1" the file is located where I want to combined all the data, this file is called "Merged data.xlsm", this workbook has a...

I've spent some time searching on the internet how to handle this issue but I think I may be phrasing the questions or issue incorrectly and I have not been able to find any material on how to handle. So... here my simple problem: I have create an array (array_Chart10a) located in a worksheet...

Good Afternoon, I have a start date call it 201801 and an end date call it 201905. Both of these values can be found within the same tbl (on Sheet 2). The 201801 is located in cell T15 (on Sheet 1), the 201905 is located in cell AB15(on Sheet 1). I am looking for a formula that would look at...

hi, I have already have vb code that opens a file etc. but I need to send this worksheet onto users ( this location will change from user to user & as will the file name). When the user 'clicks' on the macro button , they need to point to where their applicable file is located and then the rest...

Good morning, I am working on a LOTO project. I have a cell with the location of my circuit breaker that has the following contents: 23, 25, 27. This circuit breaker information is located in cell E2 of my spreadsheet. The cell I would like to insert E2's contents into has the following...

Hi, I am wanting to know if I can in VBA; Have a button that when it is clicked; Searches the name written in a drop down box, the name is then located on another sheet column 1 of "Breakfast" the sheet name of the sheet from which I want the data is located in column 54 of the same page...

Hi all, Hope everything is fine. Just to avoid duplication, I am just sending you the link (as mentioned below) where the post / thread is located. There is attachment of the excel file for better explanation. Can 'IF' condition be applied to the same Cell which already has value in it ? Can...