Three posts hunh? Will you settle for one reply?
http://www.rondebruin.nl/copy2.htm

Here is a basic tutorial for running VBA:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rob P" wrote:

Hi there, I have over 100 tabs with numerical data - each tab is named

I want to create a summary on one tab

I am having problems writing a macro to copy the data from each tab
onto the summary page

I want to paste each tab name on the summary sheet in column A with
the data in rows starting in Column B

i have written the loop - but am struggling to include the tab names -
can anyone help with this code?

any ideas? many thanks