Hi
I have been asked to write a macro that automatically copies data from one worksheet and pastes it into another one. It's supposed to look for the beginning of a name not a whole one (ex Budget instead of Budget2014). I was told to possibly use a left function somewhere in there but I'm lost.
Thanks
Bookmarks