Hey guys I am in the process of automating a lot of what I do and one area that is a sore spot for me is excel/google sheets. Do you guys have any macros you could share for sub division pricing/scrubbing?
Bwaldon I’ve got a long script I put together that automates a lot of the scrubbing of RQP data but it doesn’t do pricing. Not really sure how youd implement that. Depends on your rules/algorithm. The technical shouldn’t be too hard but the idea for how to go about it, that’s a different story.
Can you give an example of the type of rules you would want to implement? A lot of that could probably be handled with formulas or conditional formatting rather than a macro or script.
I got the visual formatting automated but hired a VBA programmer to take care of the rest. I basically get a list of sold comps, click a button, and have subdivision pricing with built in % offer recommendations based on the data. Saves me hours of work and does better job than me trying myself.