Results 1 to 12 of 12

Copy multiple rows from one book to another based on info in cell D

Threaded View

murphy Copy multiple rows from one... 08-19-2009, 06:32 AM
JBeaucaire Re: Copy multiple rows from... 08-19-2009, 07:17 AM
murphy Re: Copy multiple rows from... 08-19-2009, 08:20 AM
JBeaucaire Re: Copy multiple rows from... 08-19-2009, 09:09 AM
murphy Re: Copy multiple rows from... 08-19-2009, 11:44 AM
murphy Re: Copy multiple rows from... 08-19-2009, 11:52 AM
murphy Re: Copy multiple rows from... 08-19-2009, 12:00 PM
JBeaucaire Re: Copy multiple rows from... 08-19-2009, 01:52 PM
murphy Re: Copy multiple rows from... 08-20-2009, 02:51 AM
JBeaucaire Re: Copy multiple rows from... 08-20-2009, 08:42 AM
murphy Re: Copy multiple rows from... 08-24-2009, 07:59 AM
JBeaucaire Re: Copy multiple rows from... 08-24-2009, 11:44 AM
  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    Home
    Posts
    22

    Copy multiple rows from one book to another based on info in cell D

    Hi all,

    I am trying to do the following:

    I have a workbook with a single worksheet that has about 2000 rows, columns A, B, C, D, E & F
    Cells in colums A, B, C, E & F all have very different information in them, nothing is similar in any of those columns that I can base a criteria on.
    Cells in column D however will have 1 of about 18 possibilities in them

    What I want to do is have another workbook with 18 worksheets, each worksheet named 1 of the 18 possibilities, and somehow magically pull the data from the first workbook and insert it into the correct worksheet in the second workbook, leaving the data in the first workbook intact.

    I update the first workbook several times a day, adding and deleting from it so would need to update as it goes, or be able to run the update as and when needed.

    My skills are limited to simple formulas inserted into cells and dragging them down!

    I'd really appreciate any help with this.
    Thanks
    Last edited by murphy; 08-24-2009 at 11:51 AM.

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