Paste all sheets into one master sheet
 

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

Paste all sheets into one master sheet
 

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

Paste all sheets into one master sheet
 

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

Paste all sheets into one master sheet
 

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

Paste all sheets into one master sheet
 

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

Paste all sheets into one master sheet
 

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