Hi,
Every week, I receive a file with only the "Source" data.
Goal: To seperate the data into different tabs. Each worksheet is named from after 'Reporting Profile - ' and before '[Date Range]'
If there's was a Macro that could do this efficiently, that would be very helpful.
I've attached the sample Source Data. Typically, I get between 30 Different Reporting Profile Names.
Re: Macro to Seperate Data into worksheets
Hi,
easily doable !
Depends if it's always or not the same name source file, tabs to create in the source file or not …
With very less validation .. and as per your attachment try 1st Draft..
assuming.. you will not raise any query regarding sheet's availability or sheet name..
Please Login or Register to view this content.
Hi Marc L..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Works great! thanks alot
Last edited by nguyenak; 12-18-2013 at 08:16 PM.
Re: Macro to Seperate Data into worksheets
@Debraj Roy :
What a surprise, a ninja here ! What a clever code !
Regards !
Last edited by Marc L; 12-18-2013 at 08:32 PM.
Not sure if this should be a seperate thread.
Is it possible to save the "new worksheets" in a "new workbook"?
Try this :
Please Login or Register to view this content.
Last edited by Marc L; 12-18-2013 at 11:31 PM. Reason: optimization …
Works Perfect....thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks