+ Reply to Thread
Results 1 to 2 of 2

Save And Clear

  1. #1
    Registered User
    Join Date
    01-25-2004
    Posts
    13

    Save And Clear

    How can we get the data from Sheet 1 to Sheet 2 then clear sheet 1 at will, saving all data on sheet 2.
    Thank you.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Save And Clear

    That's a bit vague to go on.

    How big is the range ? What exactly do you want to copy ? etc....
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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] Clear contents of each sheet and save
    By Roadhouse in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-26-2018, 02:07 PM
  2. adding new customers and save/clear each use
    By mdhancockga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2015, 10:21 AM
  3. Need VBA/macro for Save & clear button
    By rajtar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 07:34 AM
  4. Command Button To Save & Clear
    By Mooseman60 in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2011, 07:38 AM
  5. Clear Cell on Save
    By karmaimages in forum Excel General
    Replies: 1
    Last Post: 10-01-2009, 07:54 AM
  6. Save the File and Clear the Macro
    By tallguy6354 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2009, 12:47 PM
  7. Save workbook name then clear when finish.
    By Jen_DPS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2006, 11:48 AM

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