I have a worksheet that has names and addresses and then one column has a # sign (this signifies end of a bundle). A coworker set up a foxpro program to pull out the bundles of two. He no longer works for my company i have no way of contacting him and i know nothing about foxpro. so i need to do this in excell.
ive attached a sample. What i need to do is cut rows based on value in BRK_LVL1. I.E in the attached sample I would not cut rows 2,3,4 but would cut rows 5 and 6.