Editing multiple text fields at once
I am creating an order form that has 164 lines (multiple pages) and I have three rows I need to work with.
1. Unit Cost - this value will not change, but I need to be able to input it all at once, so I can then reference it in the calculation column later on - How can I add values to multiple text fields at once?
2. Qty - This column of text fields allows the user to add in a quantity value (expressed as numbers) - How can I edit the format of multiple fields at once to make them all numbers?
3. This last fields calculates as 1. Unit Cost multiplied by 2. Qty to get the value. I want to setup this function for multiple fields at once? Is this possible?
Any help would be greatly appreciated. Having to format over 160 fields x 3 is a huge task.
There has to be a way to make this faster.
Thanks,
John