I'd like to put into them cost and description of products over 30 or 60 or
84 months (columns) - row is description of product. Then total for the whole
deal over the term - 30, 60 or 84 month or show totals of products by month.

"Ardus Petus" wrote:

The 30/60 columns already exist in the (new) worksheet.
What do you want to put into them?

Cheers,
--
AP

"Robog" a écrit dans le message de news:
...
How do I setup an array on a different worksheet based on the inputs of
duration of months? For example given duration of 30, 60 month - create 30
or
60 columns on another tab/worksheet within a workbook.