Forum Discussion

Copper Contributor

Oct 08, 2023

Automatically excluding cells with no data

All, I'm trying to create a robust real estate development model. It's laid out as follows: Input sheets (rent roll, other income, vacancy, operating expenses) Calculation sheet (simply aggreg...

excel

Macros and VBA

developer8888

Copper Contributor

Oct 10, 2023

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.

PeterBartholomew1

Silver Contributor

Oct 10, 2023

developer8888

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)<>"-")