+ Reply to Thread
Results 1 to 4 of 4

2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" in it

  1. #1
    Registered User
    Join Date
    03-22-2013
    Location
    Portland Oregon
    MS-Off Ver
    Excel 2010
    Posts
    3

    2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" in it

    i have a work book1 that has colums saying "art" in it. for the rows that say "art in it that are associated with that column, i need that row transferred to workbook2 in certain cells.

    i'm having trouble trying to come up with a macro to do that. infact i have never done a macro in VBA. please help!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: 2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" i

    Your question s vague on your expected results. Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: 2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" i

    Hi.

    Post a sample file.
    Click *, if my suggestion helps you. Have a good day!!

  4. #4
    Registered User
    Join Date
    03-22-2013
    Location
    Portland Oregon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: 2 workbooks transferring cell data from workbook1 to workbook 2 (when cell has "art" i

    . . . . . . .
    Last edited by garfield8626; 04-02-2013 at 01:40 PM.

+ 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