| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look at numbers between 2 numbers and copy the complete rows to a worksheet.
I have only number in column A.
It could be a 5 or a 6. Example: A1=5 A2=6 A3=6 A4=5 A5=6 A6=6 A7=5 A9=6 A10=6 A11=6 A12=6 Now I want to copy ALL the complete rows between the cells with a 5. Result: Rows 2 and 3 should be copied to worksheet 1 starting in row 5 Rows 5 and 6 should be copied to worksheet 2 starting in row 5 Rows 9, 10, 11 and 12 should be copied to worksheet 3 starting in row 5 The input of the cells in column A can be different each month. Can somebody help me with a VBA code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTO COMPLETE NUMBERS | Excel Discussion (Misc queries) | |||
| copy down without changing cell numbers to bottom of worksheet | Excel Programming | |||
| copy numbers from numbers+text cell | Excel Worksheet Functions | |||
| How do I restore header numbers for rows in a worksheet? | Excel Discussion (Misc queries) | |||
| How do I copy a formula with increasing worksheet numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
