location

Hi everybody, I haven't been able to figure this one out on my own. I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the...

I use this on a number of large files (in 2003 compatibility mode because it is much faster) and when I click Data - Advanced it always comes up with the "Filter the list in place" and every time I must click "Copy to another location" before OK. Is there any way to make Copy to another...

I have tried to adjust a VBA Code that was built for me by Fluff and I thought I was close to getting it to work, but I was mistaken. Sub Kyosti() Dim Cl As Range Dim Ws As Worksheet Dim Ky As Variant Set Ws = Sheets("Data") With CreateObject("scripting.dictionary")...

Hi, I'm trying to ask VBA to prepare a new email in outlook using the following code: strbody = "<font size=""3"" face=""Calibri"">" & _ "Colleagues,<br><br>" & _ "New Request Saved in the following location: <br><B>" & _ ActiveWorkbook.Path & "</B>\<br>" & _ "Click on this link to open the...

Hello, Using VBA I need to open a zip file where the excel file is password protected and save it on a designated location. I am able to open the file but the issue right now is, each time I run the macro, I am being asked (via pop-op window) to locate the file and than once the file is...

Is there any way to stop excel from opening subsequent workbooks at the size and or location of the last opened workbook? I wrote a script to open a specific set of data at a specific location and size. I keep this open all day but every time I open anew workbook it snaps to that size/ location...

Hello, My title isn't the best description, but this is what I'm look for and a link of the data. I am looking to have a Macro create a drop down menu (or some other way to make the selection) on worksheet "Agency" with 7 unchanging options. Location 1, location 2, location 3, location 4...

Hi, I have a series of lists based off indirects, all to get me to a final product code. Now i have the code i want to show its current location. It can be in one spot, in many spots, or in no spots which will spit out an error ("no location found") I have the list K9:T292 for the locations...

=IFERROR(IF($L$28="",OFFSET('Master Data'!B2, ($F$2-1),0),INDEX(tbl_data,SMALL(IF(tbl_data=$L$28,ROW(tbl_data)-1),$F2),MATCH(G$1,tbl_data[#Headers],0))),"") L28 is location selection L29 is product selection F1-O1 are the header cells for the scrollable area. F Column contains the "record #"...

This is complicated to explain, so bear with me please I have a for next loop set up as follows For j = 2 To LastRow Step 1 a = Cells(j, 53) If a = "1" Then tcsorting.Show Else Cells(j, 8) = Cells(j, 53) End If Next If A = 1 then a form called tc sorting...

Hi all, first time poster here. Hoping someone can help. I've created 2 spreadsheets to use in a mock scenario for testing my department's flood response procedures. On the 1st spreadsheet (called Location), I've written a macro to constantly increase the value of the river levels every minute...

Hello, I would like to transpose the first table into the second table. The table will always begin in Cell A1 but could have varying row and column lengths. I have been toying with VBA but cannot find an appropriate solution. Table 1 (original) <tbody> TEST LOCATION 2016A 2016B 2016C 2017A...

Below is a sample of the data set (starting in cell A1) I am working with (the real set has many more rows & columns). I have a formula which will return me the Min value (-2.2) and the Max value (3.0). What I am trying to do is add a formula that will return me the location of where the Min...

Hoping there is someone out there, with a genius mind in VBA or excel formulas. I data set: <tbody> Name Location Outcome Kris Barbados W John Glasgow L Kris Birmingham W John Barbados L Kris Birmingham W Kris London L Kris London W Kris London L John London W </tbody> I...

Hi all, New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense. Context: I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific. What I'm trying to pull out is any...

Hi all, I am trying to close a file using VBA which in itself is quite simple however the file name changes so I only ever know a part of the filename and its location. Location: P:\Public User Area\Purchasing\Suppliers\National Tube Stockholders\Price Review\ The section of the filename that...

Afternoon guys I use Excel 2016 to produce costing sheets for projects, and I'm trying to figure out if I can get excel to automatically work out how far each customer is from a preset location e.g. a contractor. Any ideas on how to achieve it? Not sure whether it needs to be a super-techy...

Hello All, So I have office locations in sheet 1 as follows: <tbody> Location Address City State Zipcode Chicago 243 W Jackson Chicago IL 60605 New York 505 W 50th St New York NY 10019 Los Angeles 20 Calabasas Road Los Angeles CA 98490 </tbody> Now I m looking to auto populate data...

Hello everyone, I need help finding the location of rows from 2 different criteria that are in 2 different columns. and here is an example of the data that I have which is located in sheet1 <tbody> A B C D 1 Data-1 Data-2 FIND : 2 ec x ec 3 ec z1 v7 4 dh r 5 ec v7 6 dh kr...

Hi, I was using an Index Match Array formula to get multiple results according to one criteria. In this formula, I am able to get the list of names for location "XX". That is A, D, E...