Results 1 to 3 of 3

When match text then copy ? or need better formula for this project.

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    9

    When match text then copy ? or need better formula for this project.

    Hello ,
    I want to analyze the figures for 2011 and 2012.
    I have a database where I want to analyze a product that is sold in both years and would like to automate a formula to copy data automatically when the first match with the same product in different years.

    I try some Match formula but ,may need to make a macro..



    When in "B" Column some products match, then copy info from "2012" C,D,E cells and copy to G,H,I cells.
    as examples in the attached document: B4 match with B3 then info from 2012 is C4 , D4 , E4 ) should be copied toto G3, H3 , I3

    If you can give suggestions I attach documents

    Thank YOU !!!
    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