+ Reply to Thread
Results 1 to 3 of 3

VBA code to report data when certain cell column is changed

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Boulder, Colorado
    MS-Off Ver
    2016
    Posts
    45

    VBA code to report data when certain cell column is changed

    Hi I'm new to VBA and I'm having trouble with the code I'm attempting to report the change made to each part of inventory within excel.

    The three things I'd like this macro to perform is
    1. Report the current date in the Sheet "Orders" in Column "B" when a cell in column "E" of sheet "Current inventory" is changed.
    2. Report the actual change that was made to the cell in column E. (So if we've already ordered 5 units of a part and then we order 3 more I'd like the 3 to be reported with the date that it is changed)
    3. Report the name of the part that was ordered from sheet "current inventory" -Column "A" to sheet "Orders" column "C".

    Here's the code that I'm attempted to give you an idea of where I was headed (This could be drastically off since I don't have a lot of experience with VBA which is why I'm here!)

    Please Login or Register  to view this content.
    Thanks a lot for all of your help! I've attached a sample excel file with the appropriate data needed to complete the macro (ignore columns B:D on the first sheet since they are irrelevant). Let me know if you need any more information.
    Attached Files Attached Files
    Last edited by MikeSta4ord; 10-23-2015 at 02:01 PM.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: VBA code to report data when certain cell column is changed

    Copy and paste the entire code into the sheet4(Current Inventory) page:

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Registered User
    Join Date
    05-19-2015
    Location
    Boulder, Colorado
    MS-Off Ver
    2016
    Posts
    45

    Re: VBA code to report data when certain cell column is changed

    Wow I was way off... Thanks for the lesson, I'm very grateful for your service.

    Best regards,
    Mike

+ 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. Agging report, openingbalance report,customer report vab code was not working
    By rana19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2015, 03:38 AM
  2. Replies: 4
    Last Post: 08-18-2015, 10:02 AM
  3. VBA Code to Colour a Row as data is changed
    By isherjotb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 09:46 AM
  4. [SOLVED] VBA Code to Copy Cell Value to Another Sheet When Value Is Changed
    By kev2177 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-12-2013, 07:14 PM
  5. [SOLVED] Run Code When Cell is Changed - Where am i going wrong
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2012, 03:12 AM
  6. Replies: 6
    Last Post: 08-28-2012, 03:51 AM
  7. run code when a cell is changed
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2011, 08:42 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