+ Reply to Thread
Results 1 to 4 of 4

Copy certain info in one sheet to a new sheet to a different area and rename new sheet

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    13

    Copy certain info in one sheet to a new sheet to a different area and rename new sheet

    Hi, I've been searching the web and could not find what I specifically need. I hope someone would be able to help.

    I have attached a sample sheet.

    What I want:
    1. The information in sheet (Main) must be copied to a new sheet, then the new sheet should be renamed to whatever is in cell A1:C1 (In any given month there could be between 5 - 15 new sheets that will be created)
    2. Copy from Main sheet cell A2:C2 and paste in new sheet at cell A1:C1
    3. Copy from Main sheet cell A10:C* (* means that every month the information differ, thus one month it could be two rows, where other months it could be as long as 1000 rows), paste in new sheet at cell A5:C*
    4. After information in the new sheet is pasted, the new sheet name should be renamed to the information in A1:C1

    I hope this make sense.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy certain info in one sheet to a new sheet to a different area and rename new sheet

    You do not have data in A1:C1.
    You need to attach the correct sheet.

  3. #3
    Registered User
    Join Date
    04-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Copy certain info in one sheet to a new sheet to a different area and rename new sheet

    The data in A2:C2 in the Main sheet must be copied to the new sheet to A1:C1 and thus the sheet new sheet name should be whatever the data in A1:C1 is.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy certain info in one sheet to a new sheet to a different area and rename new sheet

    I just replied to a thread in which the cells were merged. Least to say, I had a great time. If you unmerge cells, you end-up with single cell values in A2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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