PDA

View Full Version : Clear all except first row



ndendrinos
10-18-2008, 05:32 AM
In sheet1 I search a company and click the top button to get a filterd list of invoices for that company on sheet"Filtered"
BUT in need to leave the command button in row1 on sheet "Filtered" alone ... in other words the clearing of sheet "Filtered" needs to start on the second row of that sheet .

The way it is set up now I delete the command button when I filter on sheet1

Thank you

paulked
10-18-2008, 09:15 AM
Like this?

ndendrinos
10-18-2008, 09:33 AM
Exactly like that..
Many thanks paulked
.... is the "solved" option down?