Re: VBA CODE for Excel 2007 & 2010
You are insane with this lol..in a good way... Glad you took the liberties that you did. I was deleting sheet 2 entries by selecting all and deleting. Thanks for those adds. I don't know how many numbers the MLS have I think seven sounds right. I may have seen some that are eight but not sure. When I talk to my real estate agent I mention address and he says "What's the MLS #" lol... That is the only reason I am going to record it. Thanks for the date stuff... You can allow the MLS to input up to 9... I found one that was 6 but most are 7 from a quick glance. I do not know if it varies... ok my quick research says that MLS codes go by the date built and area. They are chronological allegedly. Can we just remove the parameter for MLS. I will only use five digit zips with no intentions to go to full zip codes. Thanks for all the other parameters you set... smart idea... sounds great...
How do you get sheet 2 to ....updated5.xlsm? I did a copy paste but then the macro didn't copy entries from sheet one to two... sorry I know I am illiterate with excel lol...is it an import kind of task?
Also the freeze pane went away and I did not see the toolbox in sheet two. I tried to redo the freeze pane but it either did a large pane or just the top row.... Any advice is appreciated... Thanks!
I am trying to figure out what is going on with those three entries you referenced... if you want you can just delete them as I can add them with new code to see if that fixes it. I also noticed my conditional formatting went to hell when I added the MLS # column lol... but I can fix that later on.