Results 1 to 6 of 6

copy cell value from sheet to sheet with conditions

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    7

    copy cell value from sheet to sheet with conditions

    Hi,I have two sheets and i need help with macro (VBA Code ) that can do the following:

    -copy cell value from the "exp sheet" to the "bud sheet" as follow:

    -if the code column in "exp sheet" for example (AX.0308) is found in "bud sheet" then copy each cell value in that column to the approiat "exp cells" and delete the column with shift to left.

    -if the code clolumn in "exp sheet" for example (FX.0070) not found in "bud sheet" then copy the column and insert it at the right end before "Grand Total" column .

    kindly check the attached file for more help.....

    Thanks in advance for your time and try .....
    Attached Files Attached Files

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