E=mc2
asked on
How can I sort the data shown in Sheet 1 and copy it to Sheet 2?
I would like to sort through the Data in Sheet 1, and produce the output shown in Sheet 2.
I will add much more data to Sheet 1, perhaps over 600 rows and perhaps it may grow.
Can someone help me either to use Excel, or perhaps a script to obtain the desired output?
Thanks kindly.
SortingofData.xlsxSortingofData.xlsx
I will add much more data to Sheet 1, perhaps over 600 rows and perhaps it may grow.
Can someone help me either to use Excel, or perhaps a script to obtain the desired output?
Thanks kindly.
SortingofData.xlsxSortingofData.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Instantiate an Excel.automation object, open the workbook, and then use its RUN() method to invoke the routine.
Please note that I am populating the cells in a "Sheet3" worksheet (for testing purposes). You will need to change that to "Sheet2" for your production purposes.
@100questions
You could also tweak this code and run it entirely in a VBScript environment. You will need to remove the "As datatype" keywords from the Dim statements and add constant definitions for the xlDown and xlToRight values.
You could also tweak this code and run it entirely in a VBScript environment. You will need to remove the "As datatype" keywords from the Dim statements and add constant definitions for the xlDown and xlToRight values.
ASKER
@aikimark.
Thanks, what are the steps to add this scrip in Excel?
Thanks, what are the steps to add this scrip in Excel?
1. create a module in the VBProject environment
2. paste the code/routine into the module
2. paste the code/routine into the module
ASKER
Thank you, this works great.
ASKER
How will I trigger this to run? Externally?