+ Reply to Thread
Results 1 to 4 of 4

Copy a sheet to make another sheet the same

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Houston Texas
    MS-Off Ver
    Microsoft Starter 2010
    Posts
    2

    Copy a sheet to make another sheet the same

    I downloaded a Mileage Log Template. I made 1 sheet for March 2013, I want to make another sheet for April, May, June, etc. How do I make the sheets all the same, ie, the same format with the same cells and everything else?

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Copy a sheet to make another sheet the same

    Try This -

    1) Right Click on the Sheet Name

    2) Select Move or Copy

    3) Select Create a Copy

    4) Click OK

    Make as many files as you require.

    I hope I understand your question correctly.

    Deep
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    02-01-2014
    Location
    Houston Texas
    MS-Off Ver
    Microsoft Starter 2010
    Posts
    2

    Re: Copy a sheet to make another sheet the same

    Hey Deep, thanks that did the trick, just have to change all the dates, but the format is what I needed most. Works like a charm man, thanks again. Have a great weekend

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Copy a sheet to make another sheet the same

    Glad it helped.

    Deep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-18-2014, 10:54 PM
  2. Lookup Value from Sheet 4 in Sheet 2, if found copy Sheet 2 Active Row to Sheet 5
    By lgosso23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2013, 02:51 PM
  3. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  4. Replies: 6
    Last Post: 05-02-2012, 07:07 AM
  5. How to make a new sheet and copy a column?
    By KroogerFx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2009, 03:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1