I created a worksheet to use as a sheet index, pulling info from my sheet borders/titleblocks.
The worksheet pulls several extra blank rows and I can't figure out how to get rid of them. Screenshot attached. I'm confused because there are 12 sheets and the header of row 2 correctly indicates 12. But there are 22 rows? How can I get rid of these? Messing around with adding a Criteria, it looks like I have 22 sheet borders, 12 of which have the right record attached. How do I find those extra 10 and get rid of them? I couldn't figure out how to use the Criteria to do it.....
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
jwouie
I created a worksheet to use as a sheet index, pulling info from my sheet borders/titleblocks.
The worksheet pulls several extra blank rows and I can't figure out how to get rid of them. Screenshot attached. I'm confused because there are 12 sheets and the header of row 2 correctly indicates 12. But there are 22 rows? How can I get rid of these? Messing around with adding a Criteria, it looks like I have 22 sheet borders, 12 of which have the right record attached. How do I find those extra 10 and get rid of them? I couldn't figure out how to use the Criteria to do it.....
Thanks.
Link to comment
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.