+ Reply to Thread
Results 1 to 4 of 4

track change in price coulmn

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    track change in price coulmn

    I have workbook wich I download stock every day and copy it to this workbook so sometimes the prices of item changes I want vba code to tell me that when it happened
    Like if item :

    22039 its price 1599

    If it will be for example 1449

    Its back color changed to yellow
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: track change in price coulmn

    any help ????????????????

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: track change in price coulmn

    you have 71 views on your items and no reply, that indicate the question is not clear to the forummembers.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: track change in price coulmn

    my request is that I need code store the data in "A"coulmn and the price in column "e" and when I update the sheet with new data in next day if there is change in price column in e column

    it tell me that by message and change the back color of these cells


    note : the price column is associated with art column as when code change its price change


    code price
    22039 1599
    43765 319

+ 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. [SOLVED] Excel 2013 wants to calculate Sales Price , If cost price exits and wants change SP
    By Bitto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 12:49 PM
  2. enter data in coulmn the today date appear in other coulmn and doesn't change
    By sterio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2015, 04:13 PM
  3. [SOLVED] Track High Price of Stock from Date of Purchase
    By ecoperson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2013, 02:53 PM
  4. Change percentage -> dynamically change price
    By dmb41 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2013, 11:26 AM
  5. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  6. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  7. Replies: 4
    Last Post: 08-15-2012, 09:49 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