+ Reply to Thread
Results 1 to 4 of 4

Need help with a Excel Macro (I am a Newbie)

  1. #1
    Registered User
    Join Date
    08-12-2008
    Location
    Ohio
    Posts
    11

    Need help with a Excel Macro (I am a Newbie)

    Hello... Can an yone help me please?
    I have two excel files that laid out exactly the same.
    The two files are: MB.xls and CT.xls.
    I need to check each of the columns starting at C3 in the CT file with the column C3 in the MB file, if the rate if 5% less in the CT than in the MB (in C3 cell) then keep the C3 valuie in the CT table, ELSE, take the MB C3 rate - 5% and put that in the C3 of the CT table and change the color (since it was changed). The MB table is that master so that is why I cpmpare to that file and make changes in the CT table.
    Can anyone help me with this... I know this has to be easy for someone that is verse in Excel, I am just not.

    Thanks!!!

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Welcome to the Forum. Please read the Forum Rules & then use the Edit Button to change the Thread's Title to one that complies with the Rules.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-12-2008
    Location
    Ohio
    Posts
    11

    where...

    hello, where or how do I go change the title?
    thanks for letting me know.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    Quote Originally Posted by theebookzoo
    hello, where or how do I go change the title?
    thanks for letting me know.

    Since 2 hours have expired since your post you cannot change it anymore... PM a moderator who is online with your new title.... they will change it for you.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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