+ Reply to Thread
Results 1 to 4 of 4

Data to create custom map

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    28

    Data to create custom map

    Hello everyone,
    I have an excel sheet "Data Combine" that I copy+paste data from our subcontractor. This sheet is not in any order.

    I have another excel sheet "Final Data" with a numbered column from 1-4226. Data is entered on a daily basis in the "Data Combine" that uses a vlookup formula to sort and confirm areas on the data that is missing. It enters the data in "Final Data" sheet directly next to the numbered column its data represents.

    I have another sheet "Asset" that has a map created within the cells to look like our site. Each cell has its own number in it (1-4226) that is in the order it needs to be.

    What i would like to happen is, when data is entered on a daily basis, and the row with its represented number in "Final Data" is filled (row 25 has been data next to it), I would like the cell in "Asset" that has the same number to be highlighted automatically if the cell in "Final Data" has information in it. If blank, then no change.

    Attached in the sheets I have been using.

    Any help with this will be amazing. Thank you
    Attached Files Attached Files
    Last edited by Shonky; 12-08-2019 at 08:02 PM.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Data to create custom map

    I don't know what column the number will be entered in on Sheet "Final Data", but I'm going to assume it's in Column A of the spreadsheet.
    So let's say you select this range on "Asset":
    =$A$1:$NF$22

    For Conditional Formatting in the formula you could enter:
    =ISNUMBER(MATCH(A1,'Final Data'!$A:$A,0))

    and if that's true, then fill-in purple for that Cell.

  3. #3
    Registered User
    Join Date
    08-18-2019
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    28

    Re: Data to create custom map

    Gregb11, that worked perfectly! thank you so very much for your expertise on this.

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Data to create custom map

    Glad it worked!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pull Data from Spreadsheet to create custom label
    By CLEMMER in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2018, 03:01 PM
  2. [SOLVED] Create a custom formula for data validation
    By barbercabinet58 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2012, 02:59 PM
  3. [SOLVED] Create custom dropdown list using data validation
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2012, 11:49 AM
  4. Custom Macro to Create New File from Data
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2009, 12:24 PM
  5. Create a Custom Data Entry Form
    By Nolesphan30 in forum Excel General
    Replies: 11
    Last Post: 02-05-2008, 06:27 PM
  6. How can I create a custom data form in excel?
    By candyman175 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2005, 06:05 PM
  7. [SOLVED] Can I create custom forms to add data to a Excel Spreadsheet? How.
    By TomassoP in forum Excel General
    Replies: 1
    Last Post: 01-25-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1