Results 1 to 4 of 4

Thread: Copy data from one sheet to another according rules

  1. #1
    Neophyte Josy's Avatar
    Join Date
    Jan 2013
    Location
    BRISBANE, AU
    Posts
    2
    Articles
    0

    Copy data from one sheet to another according rules



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am pretty newbie in excel programming but I have a task to complete and think the best way it to be done with VBA programming.
    If anybody can help me out with some ideas I can follow i will try to build it myself but will not reject any help with complete procedure/sub.
    Here is the task:
    I have a workbook with some data on 1st sheet (several columns in about 3-5000 lines) and a two column several lines table on 2nd sheet.
    1st column on sheet1 has words (~ 200) in random order which all listed in 1st column on 2nd sheet and assigned to 11 words in 2nd column of this table.
    I also have 11 more sheets in workbook each named by those 11 words from 2nd column on 2nd sheet.
    I would like to copy lines from 1st sheet to those sheets named by those words by matching them from table in 2nd sheet..

    Thank you for your help in advance.

    Josy

  2. #2
    Hi,

    Welcome to the kingdom of Excel VBA.

    Please provide a example workbook then its more easy to resolve your query .

  3. #3
    Neophyte Josy's Avatar
    Join Date
    Jan 2013
    Location
    BRISBANE, AU
    Posts
    2
    Articles
    0
    Hi naveed raza,
    Sorry, yes of course I can attach a sample.
    I have attached a simplified (less columns and rows in the 1st sheet and less rows in 2nd sheet) sample file.
    So I would like to build a code which will do the following.
    When I copy a new data into sheet1 ("Chargeback") it will compare 1st cell of each row (starting from "A2") to 1st column of 2nd sheet ("Team Allocation") and copy the entire row from sheet1 (or just the 1st 9 cells of the row) to approproate sheet ("Chris", "Joe", etc) starting from cell "A2" rows by rows. So building up a sheet with data for only one team member.
    The file will be shared on network for team members I hope it does not make the task harder.
    I will pass protect it and assign only one member to be able to edit each sheet accordingly but I will try to figure it out myself.
    Currently I would like only ask some help for the code doing this copying with rules.
    Thank you for any help.

    Sample.xlsx

  4. #4
    HI,

    ok, i will get back to soon with your solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •