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

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)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557962

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" wrote:


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)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557962

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557962