+ Reply to Thread
Results 1 to 2 of 2

Copy rows to other sheets (depending on certain reference column)

  1. 11-05-2014, 06:43 AM #1
    henco8
    henco8 is offline
    Registered User
    Join Date
    11-05-2014
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    4

    Talking Copy rows to other sheets (depending on certain reference column)

    Hi Guys!

    PLEASE advise! I have an excel doc with several sheets. The first sheet (MAIN) contains ALL info on our inventory.. (dates, categories, costs, etc)

    On this main sheet is a dropdown list where you specify a category for each "line" or item (row)...

    My aim is to create a sheet for every category and pull only the rows relevant to that category to a specific sheet. (There is 6 categories)

    In other words. One sheet to contain ALL info, and also a breakdown (per sheet) per category.

    THANKS IN ADVANCE and look forward to a reply!
    Reply With QuoteRegister To Reply
  2. 11-05-2014, 07:02 AM #2
    bmouse
    bmouse is offline
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Copy rows to other sheets (depending on certain reference column)

    Difficult to grasp without an example file.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy rows to other sheets (depending on certain reference column)
    By henco8 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2014, 07:40 AM
  2. Copy Column information to Rows Depending on Text
    By goodvenom7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 01:37 AM
  3. [SOLVED] Copy Column A reference number values only for updated rows
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 10:31 PM
  4. Copy formula down rows, but increment column reference
    By purplelily in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2013, 05:38 AM
  5. copy rows of data depending on value in 1 column
    By wardga in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2010, 10:30 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1