Thread: how to pull data from a specific cell on each tab as I add tabs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default how to pull data from a specific cell on each tab as I add tabs
Maybe this a option for you ?

You can recreate the sheet each time
Try this macro
http://www.rondebruin.nl/summary.htm

--

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


"egljet1" wrote in message ...
I routinely pull data from an increasing number of tabs in a worksheet. Is
there a way to pull the data from tabs as I add them without having to change
the formula for each added tab?
Reply With QuoteReply With Quote