Analysing data from several excel workbooks

  • Thread starter Thread starter Wareen Black
  • Start date Start date
W

Wareen Black

Hi,
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.

As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last 5 years in a single spreadsheet.

I appreciate any help.
Thanks
 
To give a clear answer we would need a bit more detail of the data layout
Give us a simplified version of what the data looks like
Your 'subject' talks about different workBOOKS but the text of the message
says different workSHEETS. What is the actual case?
Do all worksheets have the same layout?
What version of Excel?


best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking workbooks 4
Excel Subtracting multiple columns from another column 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Rainfall Formula 2
Summarize By Category? 3
Merging data from several Excel 2010 spreadhseets 5
Copy cell between sheets 6
Matching records based on a common field 1

Back
Top