Hi
I have 80 excel datasheets with identical headers in each
I want to bring them all into one sheet is this possible without cutting and
pasting each?
Many thanks in advance
(My first post)
Stephen

I wouldn't relish doing this with worksheet functions (where you've
posted this).
It's certainly possible with vba, so posting in that section might get
you more responses.
If you could attach a (cut down) version of your workbook it would
pre-empt a lot of questions.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121746

Thanks will do
-Stephen
"p45cal" wrote in message
...

I wouldn't relish doing this with worksheet functions (where you've
posted this).
It's certainly possible with vba, so posting in that section might get
you more responses.
If you could attach a (cut down) version of your workbook it would
pre-empt a lot of questions.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=121746

try
Consolidate under Data in the menu bar
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Its me" wrote:

Hi
I have 80 excel datasheets with identical headers in each
I want to bring them all into one sheet is this possible without cutting and
pasting each?
Many thanks in advance
(My first post)
Stephen

Place this macro in a regular module and execute from the destination sheet
1.

Sub bringinallsheetstoone()
For i = 2 To Sheets.Count
With Sheets(i)
dlr = Cells(Rows.Count, "a").End(xlUp).Row + 1
slr = .Cells.Find(What:="*", After:=[A1], _
SearchDirection:=xlPrevious).Row
.Rows(2).Resize(slr).Copy Rows(dlr)
End With
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Its me" wrote in message
...
Hi
I have 80 excel datasheets with identical headers in each
I want to bring them all into one sheet is this possible without cutting
and pasting each?
Many thanks in advance
(My first post)
Stephen

Hi,

Try this link -
http://datapigtechnologies.com/blog/...iles-method-1/

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Its me" wrote in message
...
Hi
I have 80 excel datasheets with identical headers in each
I want to bring them all into one sheet is this possible without cutting
and pasting each?
Many thanks in advance
(My first post)
Stephen