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
Here's a good step-by-step guide on the .Find Method
Search for your keyword followed by a wild card e.g. "Budget" & "*"
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks