Results 1 to 3 of 3

Moving data from one spreadsheet to another

Threaded View

  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

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