LinkBack URL
About LinkBacks
Hi @jaslake, firstly, thank you for taking the time to reply to my post, secondly, my sincere apologies for posting the file which didn't work. I've now re-attached a working file.
Once again, my apologies.
Many thanks and kind regards
Hi @jaslake, firstly, thank you for taking the time to reply to my post, secondly, my sincere apologies for posting the file which didn't work. I've now re-attached a working file.
Once again, my apologies.
Many thanks and kind regards
Last edited by hobbiton73; 09-08-2013 at 08:49 AM.
Hi hobbiton73
In what Version(s) of Excel does this Code need to run? Your Profile shows Excel 2003 but you attached an Excel 2007 (.xlsm) File.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi @jaslake, thank you very much for coming back to me with this.
I've recently migrated to Excel 2013, but I've not had chance to update my profile.
So it would be good if this would work as a .xlsm file please.
Many thanks and kind regards
Hi hobbiton73
Interesting challenge...try the Code in the attached "Sub Extract_Detail()"...it appears to do as you require.
Hi @jaslake, thank you so very much for taking the time to put this together, it's incredible.
Unfortunately, when I run this though, I receive the following error: Run-time error '91' object variable or With variable not set, and debug highlights this line as the issue:I can confirm that I have made no changes but only saved the file.
myDate = .Rows(4).Find(thisDate, LookAt:=xlWhole).Column
Many thanks and kind regards
Hi hobbiton73
Are you getting the error on your Sample File or another File?
The error you describe would indicate the Code could not find a match. Check the Format of the Dates in Column H of AllData and in the Header Row of the OutPut Sheets. The Date Formats must be consistent. In the Sample File they are Custom Formatted as mmm-yy.
Hi @jaslake, thank you very much for coming back to me with this so quickly.
I'm receiving the error on the file you provided. All I've done is download the file, saved it, then tried to run it, so I' not sure where the issue resides. The error however does occur in the 'Projects' script, so I'm not sure if that helps.
Many thanks and kind regards
Last edited by hobbiton73; 09-10-2013 at 10:33 AM.
Hi hobbiton73
I've run and rerun the Code several times in both Excel 2007 and Excel 2010 without error. The File you have should be the same File as I have. However, I'm going to ask you to upload it so I can run the Code in your File.
Hi @jaslake, thank you very much for your continued help with this.
Please find the file attached.
Kind Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks