I am looking for a was to reduce the time I spend formating data. As you can see in the example I attached my instrumentation exports data sets on top of each other (with the exception that the real data is hundreds of data points). What I would like to do is take each data set and put them on individual sheets. I'm not quite sure how to do that...
Any assistance would be appreciated. Thanks!!
ArtB,
Welcome to the Excel Forum.
Your worksheet O_all contains three groups:
Dataset O 1s:2(Spot_3_dark)
Dataset O 1s:9(Spot_3_dark)
Dataset O 1s:3(Spot_2_white)
What will the naming convention be for each worksheet?
Group:
Dataset O 1s:2(Spot_3_dark)
Worksheet name?.....
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
I have a similar problem except that my raw data has more than 170 groups. How do I create this macro? Should I copy/paste the macro above into the macro creator in my Excel 2010?
turjcxg,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks