Combining multiple sheets into one

P

pejohns

Hi

I have a shared workbook which has data added to two separate sheets by
two separate users. I need to combine this data into one summary sheet.
Each day, each user will enter a variable amount of records for the
day, and I then need to merge these two day's worth of data into one
sheet.

All the functions I can find seem to actually match and merge the data
together, wheras I want to keep all records and data, but just combine,
say, 25 records from sheet1 and 32 records from sheet2 to 57 records on
sheet3.

Any suggestions?
Thanks
Pete
 

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

Join / Merge sheet data to a consolidated list 3
Merging 2 sheets 6
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Merge multiple records to one printed sheet 1
Copy Data from One sheet to Different Sheets 1
Please help with Excel Formula 2
copy and paste 2
Copy Multiple Sheets Into One Sheet 4

Top