Re: Execute code based on specific text in target range of cells
Thanks so much for the information.
Yes, I understood the codes you gave me, however I'm still trying to understand how to apply them properly.
So far I've been getting alone quite well and these are the only issues left.
Sheet 1= "Upcoming Workflow" tab
Sheet 2= "Calendar"
Sheet 3= "Future Workflow"
Sheet 4= "2011 Published Workflow"
On Sheet 1 I have 3 main buttons. Right now the only issue I have is the "Published Workflow" button. I need the information that is cut from column C to be pasted into Sheet 4 under its respective month (according to the intended publication date"). Also I'd like --on sheet 3--for the information copied from column 3 to be pasted in sheet 1 under their respective month.
Is there a macro that can tell excel to paste the information being copied under the month indicated in the "intended publication date" queue?