help needed with excel 97
 

I need help with a problem that I'm having. I've got about 300 sheets in
my excel workbook. I need to copy the data from cell B5 on every
sheet,into a new sheet.
What can I do ?


--
sithlord3k
------------------------------------------------------------------------
sithlord3k's Profile: http://www.excelforum.com/member.php...o&userid=27513
View this thread: http://www.excelforum.com/showthread...hreadid=470255

Copy to where? You may want to try something like this:
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"sithlord3k" wrote
in message ...

I need help with a problem that I'm having. I've got about 300 sheets in
my excel workbook. I need to copy the data from cell B5 on every
sheet,into a new sheet.
What can I do ?


--
sithlord3k
------------------------------------------------------------------------
sithlord3k's Profile:
http://www.excelforum.com/member.php...o&userid=27513
View this thread: http://www.excelforum.com/showthread...hreadid=470255

i=1
For j = 1 To ActiveWorkbook.Worksheets.Count
If Worksheets(i).Name < Activsheet.Name Then
Range("A" & i).Value = Worksheets(i).Range("B5").Value
End If
Next j

--
HTH

Bob Phillips

"sithlord3k" wrote
in message ...

I need help with a problem that I'm having. I've got about 300 sheets in
my excel workbook. I need to copy the data from cell B5 on every
sheet,into a new sheet.
What can I do ?


--
sithlord3k
------------------------------------------------------------------------
sithlord3k's Profile:
http://www.excelforum.com/member.php...o&userid=27513
View this thread: http://www.excelforum.com/showthread...hreadid=470255