+ Reply to Thread
Results 1 to 6 of 6

Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

  1. #1
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    Hi,

    I want to copy contents of sheet to new workbook and delete that temporary sheet. Please help.

    Regards
    Last edited by ANUARORA; 11-18-2014 at 09:08 AM.

  2. #2
    Registered User
    Join Date
    10-29-2014
    Location
    Portland, OR
    MS-Off Ver
    MS Office 2013
    Posts
    54

    Re: Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    If you press the diagonal arrow that is on the top left of your sheet before the "1" row and the "A" column it will highlight all data on the sheet. Press CTRL+C to copy, go to new sheet and click on the very first cell, press CTRL+V to paste.
    Hope that helps.

    Kind Regards,

    Thomas Bailey

  3. #3
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    Re: Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    Thanks Thomas! But I want to achieve this through vba code or macro..

  4. #4
    Registered User
    Join Date
    08-18-2015
    Location
    Yorkshire UK
    MS-Off Ver
    office pro 2013
    Posts
    7

    Re: Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    Try this - it copies the contents of cell a1 in worksheet "name" to a1 of worksheet "name2"
    then deletes "name"
    you will need to mess with the names and ranges eg correct names and range a1:bz255 or whatever
    hope it works because I am a total newb lol


    Sub Rectangle3_Click()
    Worksheets("name").Range("a1").Copy _
    Destination:=Worksheets("name2").Range("a1")
    Application.DisplayAlerts = False
    Sheets("name").Delete
    Application.DisplayAlerts = True
    End Sub

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    Yorkshire UK
    MS-Off Ver
    office pro 2013
    Posts
    7

    Re: Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    i made a rectangle to click but you could just run it however you like - also the code lives in the workboook section

  6. #6
    Registered User
    Join Date
    08-18-2015
    Location
    Yorkshire UK
    MS-Off Ver
    office pro 2013
    Posts
    7

    Re: Copy specific data from a sheet to temp sheet and copy temp sheet to new workbook

    lol i just realised this thread is almost a year old .... i expect that the OP either sorted it or maybe became a traffic warden instead!
    lol

+ 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. [SOLVED] excel cannot complete this task when paste values from temp sheet
    By squarahollier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 09:10 AM
  2. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  3. Amend columns in a formula that lookup values from temp sheet
    By sukyb1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2012, 05:22 AM
  4. copy worksheet into temp workbook format problem
    By kinsmancrag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 06:55 PM
  5. [SOLVED] Cant Select temp Sheet
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2005, 02:06 PM

Tags for this Thread

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