i'm trying to pull one cell value from J42 from multiple sheets into a column
on one sheet. I have like 50 sheets and I need to do it on a couple of
different cells. The sheets have all different names like steve, bob, etc so
a macro on the name would be just as long. I want to look at each sheet in
the workbook except the Master Sheet and pull back the J42 cell and place
into the Master book in the appropriate column. Thanks for any help!

Vick

Hi Vick

I have a example to get the value or create a link to each cell on my site
http://www.rondebruin.nl/copy2.htm

Or create formula links
http://www.rondebruin.nl/summary.htm

--

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


"Vick" wrote in message ...
i'm trying to pull one cell value from J42 from multiple sheets into a column
on one sheet. I have like 50 sheets and I need to do it on a couple of
different cells. The sheets have all different names like steve, bob, etc so
a macro on the name would be just as long. I want to look at each sheet in
the workbook except the Master Sheet and pull back the J42 cell and place
into the Master book in the appropriate column. Thanks for any help!

Vick

first u have to use a 3D formula like SUM then try

=SUM(SheetA:SheeZ!A1)

return a sum of A1 in all sheets betwin SheetA and SheetZ including
SheetsA and SheetZ

so u have to pull ur Master sheet leftmost or rightmost

"Vick" skrev:

i'm trying to pull one cell value from J42 from multiple sheets into a column
on one sheet. I have like 50 sheets and I need to do it on a couple of
different cells. The sheets have all different names like steve, bob, etc so
a macro on the name would be just as long. I want to look at each sheet in
the workbook except the Master Sheet and pull back the J42 cell and place
into the Master book in the appropriate column. Thanks for any help!

Vick