Combine all the data's from different sheet to one sheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having data which is entered by different person's say a,b,c,d & e in
different sheets (a,b,c,d & e). I want to combine all this data into one
sheet called Combine.
Whereas the columns are same in the five person's sheet say (x,y,z). Do you
have any formula for this.

Thanks & regards,

D.V.Sreenivas
 
could use the & symbol
i.e

combine sheet cell a1
=sheet a&" "&sheetb&" "&sheetc
ect
 
You must log in or register to reply here.

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

How to I sum different data from different sheets 3
Compiling to one sheet 2
Scrabble Value calculation for Welsh words 0
Combine sheets into one 4
How Can i Link With one sheet to another sheet in Row to Column 1
Adding up total hours worked on employee schedule using various criteria 0
total columns of one sheet on another sheet 1
copying data to summary sheet 2

Back
Top