generate a Pivot Table within a worksheet that I call the “Cost Rollup” output worksh

[dono]

Problem: I need to generate a Pivot Table within a worksheet that I call the “Cost Rollup” output worksheet which will retrieve data from populated input worksheets and base worksheets somehow utilizing some VB code such as VBA macros.

Details: The book called "Environment Enabler.xls" contains a series of worksheets. Some of these sheets are to be treated as input sheets while others will be base sheets that contain parts lists with pricing and some will be output sheets used to generate reports. There is a need to generate a Pivot Table within the Cost Rollup worksheet based on drawing the necessary data from the input sheet in the Environment Enabler book labeled “Desktop HW Input and such sheets as “HW Base”. HW Base contains data such as Part description, Part number, Vendor, Cost, Maintenance Cost, and so on. The user will enter Hardware and Quantity among other things they need in the “Desktop HW Input “ worksheet. Data such as Part description and Part number is to be drawn from the

I have an input sheet in the workbook labeled “Desktop HW Input “ it needs to have linkage/visibility to such sheets as “HW Base”. HW Base contains data such as Part description, Part number, Vendor, Cost, Maintenance Cost, and so on. The user will enter Hardware and Quantity among other things they need in the “Desktop HW Input “ worksheet. Data such as Part description and Part number is to be drawn from the “HW Base” sheet.


After the User completed the “Desktop HW Input” worksheet a report “Pivot Table” could be generated in the “Cost Rollup” worksheet. The attachment uses an example of generating a Pivot Table for the maintenance cost of 1 Desktop PC for 24 to 36 months.

I am curious to know if any of you have had to write VBA macros for generating a Pivot Table similar in nature to this? If so any help would be greatly appreciated