+ Reply to Thread
Results 1 to 3 of 3

Moving data from one spreadsheet to another

  1. #1
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    241

    Moving data from one spreadsheet to another

    I have a situation where I need to do the following:

    Using the Start.xlsx file Starting on row 9, If F9 contains "x" then copy H9, I9, J9, & O9 to the workbook Desired Results sheet DATA1 to columns A,B,C, & K.

    Using the Start.xlsx file Starting on row 9, If G9 contains "x" the copy J9, N9, H9, Q9 to the workbook Desired Results sheet DATA2 to
    columns C,D, K, & Q.

    I could have as many 100 rows to do this for. (I have attached the two spreadsheets and the desired results contains the data as if it were populated as I need it to be. Any help would be appreciated.

    Thanks,

    Met
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Moving data from one spreadsheet to another

    I am not sure if you are referring to two Books or 2 worksheets on the same workbook. I assumed it is a single book.
    One of the out put shows on column J while you mentioned it as column "K"
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    241

    Re: Moving data from one spreadsheet to another

    To answer your question, the sheets are in seperate workbooks but what you provided works great for me since I am going to have to modify it in any case. (I just needed a good starting point and you provided that.) The column variance was due to an input error on my end. (I was trying to provide an example and I got my lines crossed.) In any case, you were able to read through my jumbled request and at the same time interpret what I wanted and for that, I truely appreciate your help and knowhow. Once again thanks for everything!

    Met

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting data moving from one spreadsheet to another
    By John Mitchel in forum Excel General
    Replies: 1
    Last Post: 03-20-2012, 12:34 PM
  2. Moving data from one spreadsheet to another one.
    By mroldguy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2011, 03:27 PM
  3. Moving data from 1 spreadsheet to another one.
    By mroldguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2011, 03:45 PM
  4. Replies: 1
    Last Post: 03-18-2006, 10:25 AM
  5. Moving data to another spreadsheet...
    By Guylaine_X in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2005, 02:06 AM

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