Build a Report

[JDVOIGT]

Hi, Can anyone solve my delema? I need Excel 2003 VB code for the following.

I am building a profit and loss statement on worksheet1(ws1) based on data from worksheet2 (ws2).

Ws1 report:
Selling (cellA3 “Sell_Exp” named range)
Advertising (cellA5 “Adv_Exp” named range)


Ws2 data:
About 10 columns (column “C” values identify where on ws1 to send the rows of data)
About 100 rows

I need to copy rows of data from ws2 and paste onto ws1 based on the values in ws2’s column C.

Ws1’s named ranges’ identify the data’s destinations. The ws2 data should be inserted above ws1’s associated named ranges.

I appreciate help on this one.

Thanks,
John