+ Reply to Thread
Results 1 to 2 of 2

Copy data to filtered column on another sheet in row order?

  1. #1
    Registered User
    Join Date
    11-04-2006
    Posts
    7

    Copy data to filtered column on another sheet in row order?

    I have say worksheet 1
    it has a column with figures in it
    worksheet 2
    has data filtering on
    i want to copy the figures fom worksheet 1 into a column in worksheet 2 which has data filtering on it and the row numbers change eg: 3
    7
    15 etc etc when i want a certain value in that column...
    but when the row numbers change i want them to copy the data from worksheet 1 in its order..

    like worksheet 1 row 1= 5
    row 2= 11

    i want to copy those values into worsheet 2 in the same order as worksheet 1

    when i filter worksheet 2 the row numbers change eg 3 , 7 , 15 etc but i want row 3 to have the data in row 1 of worksheet 1
    row 7 to have the data of row 2 from worksheet 1
    row 15 to have the data of row 3 from worksheet 1

    is this possible??

    i hope i have explained this properly
    Thankyou
    Dazza

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Dazza, your explanation isn't very clear can you supply some sample worksheets showing a before and after along with some comments?

    When posting in future please choose a title that reflects the content as "Please help!" doesn't help anyone least of all you.
    Not all forums are the same - seek and you shall find

+ 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