Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Is anything needed if I only load Word & Excel from Office XP Sta. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |