-
Creating Macro for dynamic range
Hello. New to the forum and to VBA and Macros. I tried doing the research first but couldn't find an example that closely represented the issue I'm having.
I need to write a macro that groups data in multiple columns based on the group number in the first column. For example:
Step |
Area |
Volume |
1 |
2.6 |
80.0 |
1 |
1.7 |
156.8 |
1 |
3.6 |
80.0 |
2 |
0.88 |
326.7 |
2 |
1.75 |
83.9 |
2 |
2.9 |
278.4 |
2 |
0.56 |
894.8 |
3 |
1.16 |
736.2 |
3 |
4.72 |
189.0 |
I want to organize the Area and Volume data in a separate table based on the associated Step number. In the end, I would ideally have 3 new tables, one for each Step (1,2, and 3) along with the Area and Volume data. For each workbook, however, the number of data points for each Step number will be different (hence dynamic range). How would I go about organizing this information based on the Step number?
I might be missing something super obvious and easy so sorry in advance if this is the case...
I appreciate the help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules