Trying to turn this
ITEM, QTY, HOURS
Pipe, 6, 12
Flange, 4, 16
Support, 1,2
Into
ITEM, QTY, HOURS
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Flange, 1, 4
Flange, 1, 4
Flange, 1, 4
Flange, 1, 4
Support, 1, 2
I can do this with a macro that I write for each quantity - eg for all with qty 6 - add five lines and copy the first line into them and then divide the hours by 6 etc. However I have hundereds of different quantities and wanted to speed up the process. So how can I write a dynamic macro that will adjust the number of lines it deals with based on the qty field, or how else could I achieve this.
Thanks
Ste4en
ITEM, QTY, HOURS
Pipe, 6, 12
Flange, 4, 16
Support, 1,2
Into
ITEM, QTY, HOURS
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Pipe, 1,2
Flange, 1, 4
Flange, 1, 4
Flange, 1, 4
Flange, 1, 4
Support, 1, 2
I can do this with a macro that I write for each quantity - eg for all with qty 6 - add five lines and copy the first line into them and then divide the hours by 6 etc. However I have hundereds of different quantities and wanted to speed up the process. So how can I write a dynamic macro that will adjust the number of lines it deals with based on the qty field, or how else could I achieve this.
Thanks
Ste4en