AgentCasts Real Estate Video Tours – The Keller Williams Miami Beach Realty / Jack Coden Group Real Estate Video Feed
from The Keller Williams Miami Beach Realty / Jack Coden Group Real Estate Video Feed
Price: USD 0
View Details about AgentCasts Real Estate Video Tours
Question by jaicee4802: MS Excel Sheet Reference?
I need to create a worksheet (about real estate in general) considering the following:
- ALL available data is entered in Sheet 1 (“Florida”)
- Sheet 2 (from select data in Sheet 1) (“Tampa”)
- Sheet 3 (from select data in Sheet 1) (“Miami”)
I have an “identifier” for each row in the first column in Sheet 1 (ex: Site T-1, Site T-2, Site T-3, Site M-2, Site M-3, etc.)
Then, let’s say Sites T-1, T-2, and T-3 go to Sheet 2 (Tampa).
Sites M-2 and M-3 go to Sheet 3 (Miami).
I am continually adding and updating data in Sheet 1 (Florida) and then sort to re-organize the data. How do I make references in Sheet 2 (Tampa) and Sheet 3 (Miami) to Sheet 1 so that when I add/update/re-sort data in Sheet 1, the references stay consistent?
I hope I’ve explained this somewhat comprehensibly. Perhaps I should be using a database such as Access, but I’m limited in resources. Thanks so much in advance for your help!
Best answer:
Answer by Scrawny
There are two possible solutions that come to mind.
List your data like you do now in Sheet 1. Sheets 2 and 3 become unnecessary if you either create a Pivot table with your data in Sheet 1 or change your listing to a table.
When your data is in a table, there are drop-down boxes attached to your column headings and you make choices as to how you want to filter your records. Eg: If Miami is one of the column entries and you choose Miami for that column, all the records for Miami are presented. If you chose Tampa, then all of Tampa’s records would be shown. For each column you would have choices to further reduce the number of records shown…..just like a database but much easier to use.
A Pivot Table can automatically categorize all of your data “on the fly” depending on how you set it up. The Pivot Table can be on the same page as the data or on a separate page. Pivot Tables are very flexible and many different reports can be generated by them.
In order to show you what each would look like, a good sample of your data would be required because without it, details can’t be given with any accuracy.
Add your own answer in the comments!
A few nice real estate miami images I found:
onyx_2_onthebay
Image by sarahelles
Most Expensive Home in Miami History – Indian Creek Island
Image by miamism
Posted via email from Ines yet again
