Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
dont know if this it to much to do via a script but here goes
i have a file with 700 lines or so by 14 columns of data , in the 4th column i have a list of numbers , what i am after is someway of when a change in the number in the 4th column appears,select all the data above with the same number and either copy/cut that data to a new file or even a new tab (naming that tab to the same as the number) in the same file , then continue till the next change in column 4 and so on till the page is empty. so i end up with a file full of tabs for each number change.... maybe its to much , thanks for trying in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
preparing pivot fields for copying and paste special for sorting | Excel Discussion (Misc queries) | |||
Autofilter/Sorting Copying Wrong records | Excel Discussion (Misc queries) | |||
Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
Sorting and copying automatically between worksheets | New Users to Excel |