Annette  Lawrence , Palm Harbor, FL 727-420-4041, Making FLORIDA Real Estate EZ  (ReMax Realtec Group)

Spam prevention
Rainmaker
672,235
Peter Mohylsky, The Beach is closed but I am open.
PrimeSouth Properties - Santa Rosa Beach, FL
I AM STILL OPEN FOR BUSINESS ALONG THE BEACH

I would need to see what you have mentioned and what you like to see or not see.  

Is the sheet password locked?  

Feb 21, 2020 06:43 AM
Ambassador
4,543,729
Bob Crane
Woodland Management Service / Woodland Real Estate, Keller Williams Fox Cities - Stevens Point, WI
Forestland Experts! 715-204-9671

How do you have those cells connected between the sheets?

do you have a formula or is it just a copy and paste situation?

I may have more perspective if you send a copy of the spreadsheet.  bobcrane@kw.com

Feb 21, 2020 07:59 AM
Rainmaker
3,545,358
Michael Jacobs
Pasadena, CA
Los Angeles Pasadena 818.516.4393

I admit I become a little frightened each time I hear mention of a "geek" and anything having to do with "pull down".  It seems like a set up for a seltzer bottle incident/punchline.  

Feb 21, 2020 06:41 AM
Rainmaker
5,670,355
Roy Kelley
Realty Group Referrals - Gaithersburg, MD

Good luck. I am not in the Geeks category.

Feb 21, 2020 08:37 AM
Rainmaker
1,286,372
Ryan Huggins - Thousand Oaks, CA
https://HugginsHomes.com - Thousand Oaks, CA
Residential Real Estate and Investment Properties

I don't think notes are referenceable in excel.  Checking.

 

Ok, so it's not doable with normal excel commands.  You have to go into VBA and do some code wizardry.   See the link: https://www.excelforum.com/excel-general/537973-how-do-i-reference-the-comments-of-a-cell.html

 

I used DuckDuckGo with a search term of "excel reference a comment".  The above link was the first result.  You can replicate the search for other options.

Feb 21, 2020 08:33 AM
Rainmaker
2,856,458
Kathleen Daniels
KD Realty - 408.972.1822 - San Jose, CA
San Jose Homes for Sale-Probate & Trust Specialist

I am a Geek of many varieties.  Like others have stated, I would need to see the worksheet.  

I am 100% confident you will get this resolved. 

Feb 21, 2020 08:28 AM
Rainmaker
1,703,626
Bob "RealMan" Timm
Ward County Notary Services - Minot, ND
Owner of Ward Co. Notary Services, retired Realtor

I'm definitely a "Geek" Annette Lawrence , Palm Harbor, FL 727-420-4041 but I'm a hardware geek and not a program geek. PLUS I never figured out any spreadsheet program. Good luck with this one.

Feb 21, 2020 07:29 AM
Rainmaker
1,588,560
Lyn Sims
RE/MAX Suburban - Schaumburg, IL
Schaumburg Real Estate

Not good enough to help you here with Excel. I'm allergic to it & break out in a rash everytime I have to use it.

Feb 21, 2020 07:26 AM
Rainmaker
968,560
Thomas J. Nelson, Realtor e-Pro, CRS, RCS-D, Vets
Big Block Realty 858.232.8722 - La Jolla, CA
& Host of Postcards From Success Podcast

Hard to say without seeing it, I do use Excel daily, but I'm not clear based on your description how to help. Sorry.

I don't try to re-invent the wheel, our MLS provides all that info for us, so I don't have to create spread sheet, I just download the pre-made up to date ones.

Feb 21, 2020 08:17 AM
Ambassador
3,598,518
Debe Maxwell, CRS
www.iCharlotteHomes.com | The Maxwell House Group | RE/MAX Executive | (704) 491-3310 - Charlotte, NC
The right Charlotte REALTOR!

So, I have a budget spreadsheet that I used (month-to-month) and I use formula to use numbers/values from previous month's sheet. 

Click on add formula and go to sheet 1 or sheet 2 and click on the box. The value will transfer to the new sheet.

Feb 21, 2020 11:43 PM
Rainmaker
4,727,962
Ron and Alexandra Seigel
Napa Consultants - Carpinteria, CA
Luxury Real Estate Branding, Marketing & Strategy

I have no idea, excel is Ron's bailiwick!  Good luck!  A

Feb 21, 2020 01:02 PM
Rainmaker
760,617
Olga Simoncelli
Veritas Prime, LLC dba Veritas Prime Real Estate - New Fairfield, CT
CONSULTANT, Real Estate Services & Risk Management

Annette, call the tech people at your MLS. They should be able to help you.

Feb 22, 2020 10:44 AM