+ Reply to Thread
Results 1 to 2 of 2

Copy Paste based on Cell Value

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Copy Paste based on Cell Value

    I tried to assemble this myself through lurking on the forums, but it seems like its just outside my skill level right now.

    I have a download that I get that shows activity for the company by Accounting Unit. With Sub Accts, Desc, Amt, and Date. I would like to try and develop a macro that copies the rows based on the Value in AcctUnit Column to the appropriate tab (the first 3 numbers in Acct Unit to match its tab) There will be times where there are multiple entries for one acctunit (rows 5&6 as example) An added bonus would be if i could get the Amount to paste in the correct columns on the corresponding tabs. Since this will be a monthly process where items do not always clear i don’t want this to paste over data that exists in the individual tabs.

    I have attached a small portion of what i am working with for a better Visualization
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-13-2011
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Copy Paste based on Cell Value

    Bump - Any Ideas?

+ 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