+ Reply to Thread
Results 1 to 1 of 1

Added codes to macro and some codes no longer work

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    Montreal, Canada
    MS-Off Ver
    Microsoft 2013
    Posts
    8

    Added codes to macro and some codes no longer work

    I have an Excel file that tracks engine status from Sales and Production departments. Columns A - M in the workbook contain data necessary to deem the engine status. Columns N - AR are used to track engine status with the following column order: Sales, Production, Day 1, Status. That repeats till Day 8 (i.e. Sales, Production, Day 8, Status).

    Column AV is called "MB51 Shipped" and column AY is "Title Transfer".

    I have 2 requests for the Macro such that:

    1) If "Shipped" in column AV, then the empty remaining Days will have "Rollup" in both Sales and Production columns.


    I got helped by someone on this and he recommended to add the following codes to "Master Worksheet":

    Please Login or Register  to view this content.
    It seemed to work as first but then I noticed the Day cells didn't return anything even though originally my macro DID return correctly the values based on IF statements. Can you please advise how I can fix this?



    2) If the last entered Sales cell says "Title Transfer" then return "x" in column AY (51st column)



    Any help is greatly appreciated! Thank you!!!!
    Attached Files Attached Files
    Last edited by alisoncleverly; 02-14-2020 at 01:31 PM.

+ 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. Codes in userform no longer working
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2017, 03:43 PM
  2. [SOLVED] Convert Y Codes from one column to another based on Unique Codes
    By ashishmehra2010 in forum Excel General
    Replies: 2
    Last Post: 10-06-2015, 09:49 PM
  3. Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  4. Replies: 1
    Last Post: 12-10-2013, 12:28 AM
  5. 17 macro ( VBA ) codes written on MSoffice-2007.Will these work on 2010?
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2013, 02:39 AM
  6. Replies: 0
    Last Post: 10-09-2013, 07:59 PM
  7. Combining vba codes makes the previous codes broken !
    By MDPLUS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 10:00 AM

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