Forum Discussion
Automatically excluding cells with no data
It's refreshing to see that you're already aware of the value of separating input from output. The way you write, it does sound as if you have at least a start at the workbook you want to end with. Rather than just verbally describing it and asking for help in completing it, is it possible for you to post a copy of the actual spreadsheet (not an image; an actual working workbook in its current state). Post it on OneDrive or GoogleDrive and post a link here that grants access to it. If all you want to know is whether it's possible for the output sheet to exclude blank rows, the answer is "Yes." If you want more help in how to accomplish that, it would help us help you to see what you're working with. As is often the case, the how-to often depends on the what-is.
mathetes thank you for your assistance. Here's a link to what I currently have:
https://docs.google.com/spreadsheets/d/13WJpbsOH4vm_L0_aoMcxzG3y1ua_xcTt/edit?usp=drive_link&ouid=103354072530995658355&rtpof=true&sd=true
On that final page I'd like for the unused rows to disappear so I can put it directly in an OM without editing it. I have a feeling this will be a VBA task but I could be wrong.
Thanks again for you help!
Clicking on that link yields this result:
So you'll need to post a link that grants access.
And i doubt that VBA will be needed; at least, my going-in premise is that a lot of things that maybe used to require VBA or macros can now be done with some of the newer functions. In this case, for example--sight unseen, to be sure--I'm expecting that FILTER might work.
- Sorry about that. This link should work:
https://docs.google.com/spreadsheets/d/13WJpbsOH4vm_L0_aoMcxzG3y1ua_xcTt/edit?usp=sharing&ouid=103354072530995658355&rtpof=true&sd=true
Thanks for your assistance.
