combining information from several sheets into one sheet

B

bhuff_1970

Right now what I am doing is copying information each time into the
different sheets, I'm sure there is a formula to make this process
easier. I want columns A - E from sheet 1, 2, 3, 5, 6 to go into
sheet 10. So Column A from Sheets 1,2,3,5,6 go into column A of Sheet
10 and so on and whenever I add to sheets 1, 2, 3, 5 and 6 the
information will automatically go into sheet 10. Is there a formula
that will work for this?
 

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

Combining two sheets of data into one and sorting by value - using macros 5
Mail Merge Help 1
Group information from several worksheets into one worksheet 1
Match and delete rows on two different sheets from reference numbers 4
comparing sheet to sheet and adding value 1
IF ARRAY with multiple conditions. 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Copy entire row from another sheet onto first sheet if a unique text matches 1

Top