nwentling5
New Member
- Joined
- Jul 26, 2011
- Messages
- 16
Hey All,
I hope I make myself clear in explaining what I am trying to pull off. If I don't, please don't hesitate to ask questions. I have attached a test workbook to make it easier to understand.
What I Am Trying to Do:
I am trying to create a dynamice Assembly Index that is updated by the "Update" button with data from the tabbed worksheets within the workbook. Each worksheet corresponds to a work order.
The data on the worksheets/work orders is dynamic and can change length. As well, the number of worksheets/work orders will change as the user creates more work orders.
At the top of each work order is information pertaining to that work order. When the data transfers over to the Assembly Index, I want this information listed to the left of the data pertaining to that work order. Then I want it to loop and do this for each work order, but have a space between each list of data.
Once the data is on the Assembly Index, I want to be able to sort the data by either: Work Order, Assembly Name, Who Added it, Date Added, and Due Date. Essentially conditionally sort the data.
Where I am Lost:
How do I properly grab the data and transfer it over and list it the way I have described? Is using multiple looped Arrays the best idea? Each group of data gets an array? If that is the case how do I grab the range that takes the information for the work order and the range for the data of that work order and list it next to each other? I think I would need to essentially connect the arrays somehow? Then I could sort based off information nested within the arrays?
Is there a better method of grouping data and transferring? I have been doing research and going through VBA books but have not been able to find anything truly promising.
Once I get the data transferred, how can I sort it the way I had described? I don't think a pivot table would work in this case.
Attached File:
Here is the attached file. The tab "After Updated Assembly Index " is what the Assembly Index should look like after I hit the update button.
Dropbox Link: http://dl.dropbox.com/u/8986524/Test3.xlsm
Notes:
I am using Excel 2007.
The data and worksheets are both dynamic.
Each worksheet is a work order.
I know your guy's experience can point me in the right direction. Any assistance is greatly appreciated!
I hope I make myself clear in explaining what I am trying to pull off. If I don't, please don't hesitate to ask questions. I have attached a test workbook to make it easier to understand.
What I Am Trying to Do:
I am trying to create a dynamice Assembly Index that is updated by the "Update" button with data from the tabbed worksheets within the workbook. Each worksheet corresponds to a work order.
The data on the worksheets/work orders is dynamic and can change length. As well, the number of worksheets/work orders will change as the user creates more work orders.
At the top of each work order is information pertaining to that work order. When the data transfers over to the Assembly Index, I want this information listed to the left of the data pertaining to that work order. Then I want it to loop and do this for each work order, but have a space between each list of data.
Once the data is on the Assembly Index, I want to be able to sort the data by either: Work Order, Assembly Name, Who Added it, Date Added, and Due Date. Essentially conditionally sort the data.
Where I am Lost:
How do I properly grab the data and transfer it over and list it the way I have described? Is using multiple looped Arrays the best idea? Each group of data gets an array? If that is the case how do I grab the range that takes the information for the work order and the range for the data of that work order and list it next to each other? I think I would need to essentially connect the arrays somehow? Then I could sort based off information nested within the arrays?
Is there a better method of grouping data and transferring? I have been doing research and going through VBA books but have not been able to find anything truly promising.
Once I get the data transferred, how can I sort it the way I had described? I don't think a pivot table would work in this case.
Attached File:
Here is the attached file. The tab "After Updated Assembly Index " is what the Assembly Index should look like after I hit the update button.
Dropbox Link: http://dl.dropbox.com/u/8986524/Test3.xlsm
Notes:
I am using Excel 2007.
The data and worksheets are both dynamic.
Each worksheet is a work order.
I know your guy's experience can point me in the right direction. Any assistance is greatly appreciated!
