Filling an Excel List

[mmlevine]

I have two lists in Excel. The first list contains a series of (305) cost centers going vertical on my spreadsheet. The second list contains (200) expense categories also vertical on my spreadsheet.

I want to match the 305 cost centers to each of the expense categories to create a total of 61,000 rows.

I really don't want to copy/paste each of the 305 cost centers.

You help is appreciated.

Thanks,

Mark

 

[Oorang]

That is an excellent description of the layout, however you need to explain how the cost centers and expense categories match up.

 

[mmlevine]

Unfortunately, they don't.

There is no common field. All cost centers chould get all expense categories.

Thanks,

Mark

 

[Oorang]

Riiighttt but do they have a cost center field in the record set?