Results 1 to 4 of 4

Data to create custom map

Threaded View

  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.

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