LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 151
Default Copying large number of sheets

Hi,

I have a spreadsheet which contains a summary page and a number of branch
sheets (each should be on a separate tab).

How do I replicate the branch sheets automatically (there are 50 of them
needed) without having to copy it 50 times?

Is there a way I can name each of the tabs automatically too, i.e with their
branch name? (Andover; Southampton etc etc)

Thanks

Amanda
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird vlookups and formulas on large sheets Devnull Excel Discussion (Misc queries) 1 October 2nd 06 11:55 PM
Copying Formulas in LARGE Files busman Excel Worksheet Functions 3 January 20th 06 06:49 PM
How to calculate average from large dataset in several sheets? Orf Excel Worksheet Functions 2 December 12th 05 10:59 AM
Getting error "selection is too large" when copying data Tootie Excel Discussion (Misc queries) 1 October 6th 05 12:19 AM
Getting error "selection is too large" when copying data Tootie Excel Discussion (Misc queries) 0 October 5th 05 08:42 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"