Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Macro Question 1 While in a spreadsheet, I want to "find" pertinant data, and delete all other non-pertinant data. This is what I currently have.... In column B there are codes that look like this: 13-BS, 35-BS, 45-BS, etc (9 codes all together). I want to find all the data in column B that have that specific data, and delete all nonspecific data. I also want each code to have its own worksheet in my workbook. Any ideas how I can get a macro to do that? Macro Question 2 How can I select a non specific data range after using a find key....(Ex. I find code 13-BS in column B, I want to select all data under it, but not above). Any ideas??? Thanks for all your help!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting excess data in a macro | Excel Discussion (Misc queries) | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I "index" data in a line graph? | Charts and Charting in Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |