Hello,
I have a macro that I just can't get to work. Everything up to the loop works as expected. I'm not sure why this isn't working!
The macro should take the data from the data entry tab and bring the data to the individual data worksheets (one per tab). I have this working on a different survey project but can't seem to get this one to work.
Any thoughts or advice would be greatly appreciated. The test file is attached.
Please Login or Register to view this content.
Last edited by yunesm; 10-10-2011 at 08:13 AM. Reason: SOLVED
The loop is working fine, your problem is the formatting of your date,
this line:
Should be:Please Login or Register to view this content.
Your code is failing because you are trying to find "Oct-11" rather than "10/01/11"Please Login or Register to view this content.
I figured I was missing something obvious!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks