location

  1. A

    search and find location of colorindex = 16

    I have several locations in my spreadsheet that have merged cell location that has the colorindex of 16. I want to save the address of the different locations in my sheet that have colorindex of 16 to several variables or an array.. How can i do this? thanks
  2. J

    At a loss & Looking for help.

    I have a workbook that has over 25,000 contacts that includes Name - Email - Phone Number - Location - City - Role. I am currently using a indirect list validation to sort between Location - City - However Roles are not filtered by City - they are filtered by location... This leaves roles...
  3. P

    Splitting pipe delimited cell into named columns

    Hi all Hoping someone may be able to help something I'm stumped on. We have a hierarchy file where the core data comes in a pipe delimited cell like below. network_CAR|subnetwork_GARAGE|subnetwork_DEALER|KMBINDIA|KMBINDIA_1|KMBINDIA_2|KMBINDIA_3 I need something that takes this and outputs...
  4. V

    Highlight cells based on criteria

    Hello All, My first question in awhile here. So, my question is this... If the cell in the column named "office" is not blank, and the cell in the column named "Location" does not say "America", highlight the cell in the "Location" column red. A couple of things to note.... 1. I would...
  5. F

    Power Query Load data into Workbook but split onto different worksheets

    Does anyone know if it is possible to have your data and then when you load it back into the workbook it breaks the information down based on a column value? The only way I can see to do is to reference the original data and select each location manually for each new query. but I will have...
  6. S

    Linking appointment schedule and reminder

    Hello, I have a daily appointment schedule that is going to be shared with 3-4 other people. We all work at the same company but at different locations. The schedule is for a truck washing station for our company trucks. Essentially the different locations are going to send their trucks to...
  7. P

    Inserting Hyperlink into body of email sent from excel

    Hi all, I have tried searching threads and I am still struggling to find an answer that works for me, so I am hoping that you can help. I have a complicated workbook that is used for event planning purposes. The template is saved to various project folders before use- the project folders are...
  8. T

    Creating Duplicate Rows

    Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...
  9. C

    macro to email worksheets to email list

    i have workbook which contains data on inventories based on location. Each location has a tab which is named for the location. I want to email each tab/worksheet to the respective manager without doing so one at a time manually. So far cannot grasp how to do so. I have a list sheet within...
  10. T

    VLookup - MAtch- INDEX with multiple values across sheets

    Hi All, I have two sheets that I am working on ='Table Of Values'! and ='Report Template'!. In cell AE14 of the sheet ='Report Template'! I have a name of the city. I would like to match and list the related data of the column "Location Rates" that are in C9:C192 in ='Table Of Values'!. I also...
  11. L

    Excel Referencing File Locations

    I have a spreadsheet of which I have built VB code to import a couple of text files and then use MSquery to combine these into one table of data. My question is that currently it references itself in a specific location ie. With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...
  12. J

    Dealing with #n/a in application.vlookup

    Hi, I am attempting to use Application.Vlookup rather than input my Vlookup formula within the cell. After a lot of reading I still don't understand how I can deal with #N/A. So to previously deal with #N/A, I would have entered as a formula this ISERROR...
  13. H

    Count Unique Text Values of Each Location Based on a Report Date

    I apologize as I'm sure this has been answered verbatim in another post but after searching I could only find pieces and wasn't able to put it together myself. I found a Formula that counts all unique items in column E, but I need that to based on location and date. Here is a sample of my data...
  14. F

    Formula Using a Variable Cell Location and a Fixed Cell Location

    Hello, I'm trying to do two formulas on a spreadsheet, both of which involve a fixed cell location (B8) and a variable cell location (depending on how many rows are generated each time). The first formula is a simple sum of all the columns from C onward for that row that I want to copy down to...
  15. P

    Function for Cell Location

    Hi, I think I am looking at this the wrong way but is there a way for me to use a formula to use this to identify a location? I am using a looking for example and I want my formula to pull the location of the cell for one of the parts of the formula. Ill paste formula below...
  16. M

    VBA to save a file copy as a backup (.XLK) file to another location

    Hi all. I need to autosave a backup copy of a critical file to another location. I cannot use the default location even though the file name clearly states BACKUP and has warning messages when opened. For some reason users will still try to use those files. I have looked at file format...
  17. R

    Sorting and Filtering with Empty Cells

    Hi Folks, I have quite a large sheet formatted something like the below. Blank cells share common data with the populated cell above them, maybe not great formatting but it is what I get. I would like to be able to sort or filter by location for example with the empty cells below South3 being...
  18. N

    Save file in new location.

    Is there a VBA code that I can add the end of my macro that will save the file with todays date (YYYY-MM-DD format) at a specific location? The location is different than the orginal document. Location: C:\Users\nanogirl\Desktop\2018 WIP\Reports File Name Example: Metrics 2018-05-24.xlsb...
  19. L

    Excel MSQuery back on itself

    I have a spreadsheet of which I have built VB code to import a couple of text files and then use MSquery to combine these into one table of data. My question is that currently it references itself in a specific location ie. With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top