Hi,
I have a spreadsheet that is a database of certain houses in the area for sale, with lots of associated property data. It is in a table format so I can easily change the order based on whatever aspect of the property I am trying to compare.
In another worksheet I have a more readable version of the same data, nicer order, less detailed info. It takes its data directly from the worksheet with the table.
When I delete lines from the table (which I do once I'm narrowing down a search), the corresponding line in the readable (comparable) worksheet doesn't disappear, leaving a whole lot of blank rows.
Funny thing is, I'm sure I remember having this work properly a while back. I'm not sure what I've changed.
Is anyone able to fix what I have done?
Thanks
Bookmarks