I would like to call Excel's 'advanced filter' with VB, then ,using code, select the first and second records returned cell by cell . Each record will have 7 feilds. Then have my changes (in code) set to the filtered records (as well as their parents if copying is nessessary). I'm trying the offset method to move down, but if row5 is the second record I end up on 1st row selected +1. If I copy the filter results to rows 1,2,3,... I can select them but I can't save them without duplicating the info. Please help! I'm doing this project as a confidence boost but finding it tough to find the correct properties.
