Results 1 to 2 of 2

Thread: Moving row to different sheets depending on number in column A

  1. #1
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12

    Moving row to different sheets depending on number in column A

    Hi
    I have attached a small workbook,

    I have to copy around 1000 rows of data each month and split them manualy, is there a way i
    could drop all data in the first sheet then at a press of a button all rows from column b-k would be moved into
    different sheets depending on the number in column A
    i.e 40 = bradford 45=hull 46 = york etc there are 16 different groups that i will eventually add to the work book


    Thanks for any help on this

    Peter
    Attached Files Attached Files

  2. #2
    Member
    Join Date
    Jun 2013
    Posts
    93
    Rep Power
    12
    Quote Originally Posted by peter renton View Post
    Hthere are 16 different groups that i will eventually add to the work book
    if you add them it will be very simple

Similar Threads

  1. Sending Data From User Form To First Empty Row Of Sheets
    By paul_pearson in forum Excel Help
    Replies: 21
    Last Post: 08-14-2013, 11:04 PM
  2. Replies: 8
    Last Post: 07-01-2013, 03:52 PM
  3. Replies: 2
    Last Post: 06-24-2013, 07:40 PM
  4. Replies: 7
    Last Post: 04-21-2013, 07:50 PM
  5. Converting a Column Number to a Column Letter
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 12-17-2012, 02:29 AM

Posting Permissions

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