Workbook started running very slow

I have a workbook with several sheets in it. Nothing too fancy, some conditional formatting, a few drop down lists, 3 simple macros and a little bit of code on two of the three sheets. As I was building it it was running really fast, the macros would happen almost instantaneously. The data that moves when you select "CLOSED" on one of the drop downs would move to the other sheet without even a blink.

Now when anything moves, or a macro is run it's doing it in slow motion, slowly going through each step before completing. I'm not sure what I did or at what point is started running really slow. Maybe it's just my laptop??? The workbook is too big to upload...can I rename it something that will make the file size smaller so I can upload it for review?

Thanks all - love this forum!

Evan

Here is the code from one of the slow moving Macros:

Please Login or Register  to view this content.

And here is the only code I have put in on the slowest of the three worksheets...

Please Login or Register  to view this content.

Thanks for the reply Roy...Yes the first code is basically pasting the value of one cell to many cells throughout the workbook. Basically someone can select their location, and then based on their selection the macro copies their location to more cells across the wb. From trolling around the forums it looks like that is an extremely elementary way to do it, but it was the only way I knew how. That's also probably why there is a bunch of unnecessary steps in there since I don't actually write the macro. I just hit record and go through the steps, I know beginner stuff.

As far as the selecting, can I just plain delete the command "select" and still have it work? Any better way to accomplish what I'm after without a clunky macro like this?

Thanks again!
Evan