+ Reply to Thread
Results 1 to 2 of 2

Macro find and change value according to table

  1. #1
    Registered User
    Join Date
    11-23-2010
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro find and change value according to table

    Hi there,
    I'm new in this forum and I have already a question...., well a macro to create in fact.
    I hope you will be able to help me as my VBA knowledge are quite limited (But I'm a quick learner)

    What I'd like to do:
    I have a big table which includes codes, names of ppl, products, etc.... that I need to reorganise every week by changing always the same thing (Some codes, some group, etc...)
    Obviously every week the table is different except its format (Always the same layout) and the "rules" (to reorganise the table) don't really change.

    I have added 2 enclosed files to get you a better example.
    - "Table to modify" is well the table to be modified
    - "Rules" is the file containing the rules, ie the changes to do.

    I'd like that the files "rules" include a macro which asks me to call the file "Table to modify" of the week, as every week it's a new file (Path = ThisWorkbook.Path by example) and that the macro changes the values of the table to the correct row/column and if and only if its value is different of the value in the "rules" file. (A color code will be nice, let's say in Yellow, to be applied to each modified value. Easier to track)

    Any idea ?
    Need clearer explaination ?

    Thank you !!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-23-2010
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Macro find and change value according to table

    I actually didn't succeed to go far with my macro...
    Any help will be more than welcome !!!
    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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