merging worksheets

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

Guest

hi everyone,

everyone in the office has created their own phone list on excel (with well
over 300 entries each). i've been tasked with consolidating all of these
worksheets into one common file. how do i merge worksheets data? i've
standardized all of the worksheets so they look the same, but am dreading
going line by line to get all the info together.

thanks,
 
Hi,

I am trying to do the same thing. I am NOT proficient in Excel at all, so
all the answers I have read so far may as well be in Greek - it shows all
this code, but I have no idea where to put it.

Can anyone help me in simple, understandable terms?

Thank you!
 
Hi Kate

Are all workbooks in one folder ?
Do you want to copy all data or a range to the sumary workbook ?
Have every workbook one or more sheets ?
 
Back
Top