Combining data from different sheets in one

  • Thread starter Thread starter viktor
  • Start date Start date
V

viktor

Hi all,

this is my first post here, and hopefully I'm not asking to much to get
an answer.

The problem:
I have data on several sheets. Every sheet contains data on only one
customer, but the layout is the same - number, name of the order and so
on. I need to create a cumulative sheet that would contain all of the
information at one place. I could do it manually, but it takes too much
time. Any ideas on how I could get this to work automaticly?

Thanks
Viktor
 
You can do this with a formula where the sheet name is in a11 down
=INDIRECT(A11&"!a1")
or a macro
 
Back
Top