Help With Excel Totals Maniputlation

[bstafford]

Hi,

Need some help on how to manipulate an excel report that has sales monthly sum totals and would like to export each cell to a new worksheet.

The original report is to busy with many part numbers that get converted during the month and sales is only interested with the Total cumulative sales amount.

How can I take the sum total cell of each customer, each month for the last 6-12 months and pull them to a summary worksheet by customer. I would like to show what I have and what I am trying to achieve with the new report. Currently it is done manually by inputting the amounts of each part for each day for each customer and the result is shown in excel.

I have a database program that I can export into excel, but need to get the data into a different format, I can show this format in excel that I currently have.

It is difficult to explain, so can a file be uploaded to show what I am trying to accomplish?

Can anyone help me with this please?

Regards

Bill