Quote:
Originally Posted by Spencer101
Are you adverse to having a few hidden columns to do all the hard work for you?
Basically, there are two ways of doing this that I can think of. One involves some quite complex (and by that I mean awkward to maintain when data requirements change) formulas. The other involves some hidden "helper columns" that are nice and easy to maintain.
|
Hi Spencer,
Hidden columns would be fine as long as they are to the right of the existing data as I will need to copy paste blocks of the data to another spreadsheet.
Data in the SS tab will change completely from job to job but the columns will not. The other tabs will stay the same throughout if that helps any.
Thanks