I am not very good when it comes to this kind of thing with excel, however I am wanting to compile a spreadsheet from a report generated by Crystal Reports that has been exported to excel format as shown in sheet 1 of the attached example. I need to compile it in the format shown in sheet 2 without having to manually enter it (as there is approx 3000 records). Can this be done?
Thank you in advance for any help
Kind of brute force but it will work as long as your report is ALWAYS as the one shown. This kind of macro is very sensitive to report variations. But usually, you can trust the constant behavior of those software.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Excellent, worked like a charm and saved me 2 weeks work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks