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 ?
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 ?
Copy to where? You may want to try something like this:
http://www.officearticles.com/excel/...worksheets.htm
************
Anne Troy
www.OfficeArticles.com
"sithlord3k" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks