View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default copy same cell from different ascending sheet into a table?

You can copy or create a link

Try this
http://www.rondebruin.nl/summary.htm

--

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


"Roog" wrote in message ...
I have 125 sheets with every sheet displayed in the same manner. Now I would
like to copy cell B2 (and some more cells) of every 125 sheets into one new
sheet (table). As it would take too much time to copy everything manually, i
would like to know if there is a quicker way?

hope anyone can help me,

Roog