Forum Discussion
Automatically excluding cells with no data
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.I think my previous answer focussed on bringing together multiple tables with similar positioning and layout. If it is simply a matter of transferring non-black records to a holding table then the FILTER function could be more appropriate.
= FILTER(rentRoll, CHOOSECOLS(rentRoll, 1)<>"-")Now that I've looked at it, I don't see a solution using simple function(s) or formula(s). So if the solution offered by PeterBartholomew1 works, use it.
The only other thought I might put forth--which might require rethinking how you arrange the input and calculation sheets--would be to use Microsoft Word's MailMerge capability, with Excel as the data source, to produce that nicely formatted and organized printout. Years ago (decades ago, actually), when in my corporate position, I used MailMerge, with Excel as the data source, to print hundreds of personalized letters, letters with varying numbers of rows of data and other personalized paragraphs, when we were divesting a division and letting employees know what benefits they were entitled to.
That capability of Word would enable you to produce a nicer looking document. But, as noted, I suspect it would also require some extensive re-thinking of the Excel database components. So if @Peter's solution works, use it.
