Combining multiple sheets into one

  • Thread starter Thread starter pejohns
  • Start date Start date
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
 
Back
Top