I have 96 different spreadsheets. I would like to make this one master
spreadsheet. Make a version control so when the user opens the spreadsheet it
will connect to my access database and it will tell the user they need the
new version. That part is all set.

I need help on coping the information from the old spreadsheet into the new
spreadsheet. What is the best way of doing this? I have many built in
functions to the menu bar as well. Is there a copy all excel spreadsheet and
past all into another spreadsheet.

Thanks in advance

the best way of copying a worksheet is to use the tab at the bottom of the
worksheets (i.e. Sheet1). Right click the tab and select Move or Copy. Then
select the "to book" (there is a new book option). Check the box that says
COPY and select the "before sheet:".

"Crazyhorse" wrote:

> I have 96 different spreadsheets. I would like to make this one master
> spreadsheet. Make a version control so when the user opens the spreadsheet it
> will connect to my access database and it will tell the user they need the
> new version. That part is all set.
>
> I need help on coping the information from the old spreadsheet into the new
> spreadsheet. What is the best way of doing this? I have many built in
> functions to the menu bar as well. Is there a copy all excel spreadsheet and
> past all into another spreadsheet.
>
> Thanks in advance
>

Thank you but I was looking for some VB code. Do you know of any websites or
would you have any?

Thanks

"Joel" wrote:

> the best way of copying a worksheet is to use the tab at the bottom of the
> worksheets (i.e. Sheet1). Right click the tab and select Move or Copy. Then
> select the "to book" (there is a new book option). Check the box that says
> COPY and select the "before sheet:".
>
> "Crazyhorse" wrote:
>
> > I have 96 different spreadsheets. I would like to make this one master
> > spreadsheet. Make a version control so when the user opens the spreadsheet it
> > will connect to my access database and it will tell the user they need the
> > new version. That part is all set.
> >
> > I need help on coping the information from the old spreadsheet into the new
> > spreadsheet. What is the best way of doing this? I have many built in
> > functions to the menu bar as well. Is there a copy all excel spreadsheet and
> > past all into another spreadsheet.
> >
> > Thanks in advance
> >

Copying a worksheet in VBA is easy. If it is going into the same workbook
then use this

Sheets("Master").copy

Sheets("Sheet1").Copy after:=Sheets(Sheets.Count)
Set NewSht = ActiveSheet


for copying multipel sheets

for i = 1 to sheets.count
Sheets(i).Copy after:=Sheets(Sheets.Count)
Set NewSht = ActiveSheet

next i


"Crazyhorse" wrote:

> Thank you but I was looking for some VB code. Do you know of any websites or
> would you have any?
>
> Thanks
>
> "Joel" wrote:
>
> > the best way of copying a worksheet is to use the tab at the bottom of the
> > worksheets (i.e. Sheet1). Right click the tab and select Move or Copy. Then
> > select the "to book" (there is a new book option). Check the box that says
> > COPY and select the "before sheet:".
> >
> > "Crazyhorse" wrote:
> >
> > > I have 96 different spreadsheets. I would like to make this one master
> > > spreadsheet. Make a version control so when the user opens the spreadsheet it
> > > will connect to my access database and it will tell the user they need the
> > > new version. That part is all set.
> > >
> > > I need help on coping the information from the old spreadsheet into the new
> > > spreadsheet. What is the best way of doing this? I have many built in
> > > functions to the menu bar as well. Is there a copy all excel spreadsheet and
> > > past all into another spreadsheet.
> > >
> > > Thanks in advance
> > >