I could do that, but there is the possiblity that we will continually change
information till the customer is satisified with the end result, which means
that you will have to cut and paste numerous times. Which is wasting time
and you have the possibility of forgetting one time and giving the customer
the wrong information.

"ShaneDevenshire" wrote:

Hi Jeff,

I'm probably missing something here, but copy and paste?

--
Thanks,
Shane Devenshire


"Jeff" wrote:

I have 8 groups (each group is column for description, and one for quantity)
of colums, 400 lines long that have formulas in them to get the information
to come from other sheets and I want to combine them.

Each group is a quantity of pieces needed to produce a job, some groups may
be blank some may not, but I need to all of them into a possible 3200 line
items of descriptions with quantity so I can do a pivot table for my quote.

Any ideas would be much appreciated.

Jeff