G
Guest
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
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