View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default merging worksheets

Hi thebaldsoprano

Look here for a few code examples
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"thebaldsoprano" wrote in message
...
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,