mandylima123
New Member
- Joined
- Jun 3, 2015
- Messages
- 4
Hello!
I am an absolute beginner in VBA and have struggled to write a MACRO that will help me format a Data Center report that I must complete weekly with thousands of lines. Any help will be so greatly appreciated!!!
In the report, if the text "-C0" (a dash followed by the letter "C" and the number "0") is found in column B in any part of the text, I need to insert 7 lines below, copy the information in all cells of that row (except column D) to the 7 new rows below, and in column D of all 8 rows, put: 1, 2, 3, 4, 5, 6, 7 and 8 in that order. The "-C0" indicates that the device described is a chassis and column D then indicates the 8 blades on each chassis.
Thank you in advance to anyone willing to give this a try! This would be a lifesaver for me!
-Mandy
I am an absolute beginner in VBA and have struggled to write a MACRO that will help me format a Data Center report that I must complete weekly with thousands of lines. Any help will be so greatly appreciated!!!
In the report, if the text "-C0" (a dash followed by the letter "C" and the number "0") is found in column B in any part of the text, I need to insert 7 lines below, copy the information in all cells of that row (except column D) to the 7 new rows below, and in column D of all 8 rows, put: 1, 2, 3, 4, 5, 6, 7 and 8 in that order. The "-C0" indicates that the device described is a chassis and column D then indicates the 8 blades on each chassis.
Thank you in advance to anyone willing to give this a try! This would be a lifesaver for me!
-Mandy
Last edited: