+ Reply to Thread
Results 1 to 2 of 2

Data separation to new worksheet

  1. #1
    Registered User
    Join Date
    04-08-2008
    Posts
    1

    Smile Data separation to new worksheet

    Hello

    I'd like to be able to move (cut and paste) row data (recognised by a change in a column) so this might be a number of rows by columns to different worksheets on the same workbook and (hopefully but not essential - name the worksheets by the name of the column)

    Any ideas?


  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by ckearney
    Hello

    I'd like to be able to move (cut and paste) row data (recognised by a change in a column) so this might be a number of rows by columns to different worksheets on the same workbook and (hopefully but not essential - name the worksheets by the name of the column)

    Any ideas?

    Hi,

    I don't quite understand when you talk about a change in a column. Do you mean when a cell in a row in the column changes compared to the cell in the row above it, or are you referring to changes on the same row between columns, or maybe both?

    However my general approach to tasks like this is:
    Set up a loop in a VBA procedure which tests a cell in the desired column with the cell below it. I generally use the loop counter in something like

    Please Login or Register  to view this content.
    In this case set up a variable which remembers the row number of the previous change in value and use this in determining how many rows you need to include in the cut.

    As you're doing the cutting, identify in another variable the column heading of the data being cut, and use this variable when you do a :

    Please Login or Register  to view this content.
    HTH

+ Reply to Thread

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