Results 1 to 10 of 17

Thread: Looking at data sheet and then transferring data according to date to fixed range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-20-2013, 03:06 PM #11
    Ingolf
    Ingolf is offline
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    14
    Hi,

    Try this ("under" CLEAR DATA button) code:

    Code:
    Private Sub CommandButton1_Click()
 Range("O6:S11,O15:S20,O24:S29").ClearContents
 MsgBox "Data Has Been Deleted"
End Sub
    Last edited by Admin; 12-20-2013 at 09:31 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Pull data within the work sheet and save as master sheet with pulled sheet name.
    By amar.kshirsagar in forum Excel Help
    Replies: 2
    Last Post: 09-30-2013, 03:40 PM
  2. VBA To Separate One Long Row Data Into Multiple Rows Of Fixed Columns
    By rxpsych in forum Excel Help
    Replies: 10
    Last Post: 08-31-2013, 06:56 PM
  3. Rearrange A Delimited Column Of Data In To Separate Rows With Fixed Number Of Columns
    By digitalcaptive in forum Excel Help
    Replies: 3
    Last Post: 07-29-2013, 11:32 PM
  4. Transferring Data From One Worksheet To Another If A Condition Is Met
    By bunni1031 in forum Excel Help
    Replies: 2
    Last Post: 07-02-2013, 06:52 PM
  5. Lookup Start Date And End Date Range For Specific Date Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 06-15-2013, 12:40 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
  •  

Forum Rules