Excel Analysis

[Guest]

Hello,

I am working off a workbook which contains 18 worksheets with each sheet
representing a department.The data in each sheet contains 4 quarters of sales
of multiple categories such as rakes, hoses, shovels.I have just been given a
budget amount to do an overall analsis to this so what would be the best
method or tools to consolidate these 18 sheets to compare Actuals Vs Budget .

Thank You

 

[robert111]

on each worksheet insert a new column A and put worksheet name in cell
A1 and copy this right down.

Take worksheet name1 and copy it to a new sheet, sheetnew.

now take worksheet name2 and copy the data, not the headings, to
sheetnew.

copy all of them

now analyse with pivot table or sumproduct table(s)

 

[Guest]

Hi,

I have 18 sheets so am i supposed to repeat this process (copy the entire
sheet cells or just totals)for each sheet?

thanks

 

[robert111]

It depends what you wish to analyse. It doesnt take long to copy 18
sheets, maybe 5 minutes. Then in the future you will be able to add new
data to the new combined sheet only.

Bob