T
TinaF
I had a spreadsheet template with columns as follows (and rows of
about 110 items):
Quantity Item Cost per Unit Hours per Unit Ext.
Cost Ext. Hours
Ground Mat/Grid 2.00 0.00
Ground Rod/Point 0.30 0.00
The Ext. Cost and Ext. Hours columns have formulas that will multiply
the quantity by either the cost per unit or hours per unit (or both).
There are also rows at the end of the list of items that do NOT
contain item names, cost per unit amounts or hours per unit amounts.
They only contain the extended cost and extend hours formulas. These
rows are for estimators to add unique items on the fly.
Estimators will go down the quantity column entering quantity numbers
and, if necessary, unique items with quantities at the end of the
list. Once they've filled in all their quantities I've set up a
"Filter Quantity" button that will filter the quantity column so that
only nonblanks show.
entered.
I've tried several times to record a macro with varying results.
Previously my macro would ignore (not print) any unique items that
were added in rows below the standard list. My re-recorded macro now
seems to be printing ALL the rows below the standard items even though
they are technically blank - i.e. they have no quantity, item name,
cost or hours filled in but they do have the cost ext. and hours ext.
formulas.
Help! It seems like it should be so simple.
Thanks,
Tina
about 110 items):
Quantity Item Cost per Unit Hours per Unit Ext.
Cost Ext. Hours
Ground Mat/Grid 2.00 0.00
Ground Rod/Point 0.30 0.00
The Ext. Cost and Ext. Hours columns have formulas that will multiply
the quantity by either the cost per unit or hours per unit (or both).
There are also rows at the end of the list of items that do NOT
contain item names, cost per unit amounts or hours per unit amounts.
They only contain the extended cost and extend hours formulas. These
rows are for estimators to add unique items on the fly.
Estimators will go down the quantity column entering quantity numbers
and, if necessary, unique items with quantities at the end of the
list. Once they've filled in all their quantities I've set up a
"Filter Quantity" button that will filter the quantity column so that
only nonblanks show.
print the spreadsheet down to the last row that has a quantity/itemFrom here I need a "Print this Page" button with a macro that will
entered.
I've tried several times to record a macro with varying results.
Previously my macro would ignore (not print) any unique items that
were added in rows below the standard list. My re-recorded macro now
seems to be printing ALL the rows below the standard items even though
they are technically blank - i.e. they have no quantity, item name,
cost or hours filled in but they do have the cost ext. and hours ext.
formulas.
Help! It seems like it should be so simple.
Thanks,
Tina