+ Reply to Thread
Results 1 to 3 of 3

Using a Macro To update cell data

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    54

    Using a Macro To update cell data

    So I have been trying to plug away at this but am getting no where fast.

    I have a set of job numbers on sheet 2 that is pulled from sheet 1, when the job numbers are pulled over it also pulls the due date. The problem I am having is that Sometimes the due date gets pushed out and I need help writing the macro that will pull in the new date

    This what I have so far
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Using a Macro To update cell data

    hello wjk221,

    I looked at your workbook but am struggling (OK it is friday night after all) in understanding what your problem actually is????

    any chance you an update the attachment to explain the inputs AND most importantly the desired results and why they should be the results

    as I said, sorry but is TGIF in OZ

    Jmac

  3. #3
    Registered User
    Join Date
    11-15-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Using a Macro To update cell data

    I am trying to make it so that when a due date is changed on the Input sheet it will also change the due date on the PerformanceMatrix sheet.

+ 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. Macro-need help sorting data to other worksheets/update as new data is entered.
    By Beefy1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2014, 12:09 PM
  2. Replies: 1
    Last Post: 09-11-2013, 10:53 AM
  3. Replies: 0
    Last Post: 05-10-2013, 08:08 AM
  4. MACRO HELP - Need to update a cell with data from a list in another sheet
    By Excelgnome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2012, 06:47 PM
  5. Creating a macro to auto-update external data and time macro was excecuted
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 05:21 AM

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