Results 1 to 10 of 17

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

Threaded View

jeff Looking at data sheet and... 12-16-2013, 06:59 PM
Admin Hi Put this code in the... 12-18-2013, 05:27 PM
jeff Hi Admin I placed in the... 12-18-2013, 06:09 PM
Admin That's because the date is... 12-18-2013, 06:27 PM
jeff My apologies It does... 12-18-2013, 06:35 PM
Admin Hi Try this. Private... 12-18-2013, 11:03 PM
jeff Thanks Admin I learnt a... 12-19-2013, 11:18 AM
Admin Hi Remove all the codes... 12-19-2013, 01:02 PM
jeff Hi Admin Excellent and... 12-19-2013, 01:43 PM
jeff Hi Admin I updated the... 12-20-2013, 06:20 AM
Ingolf Hi, Try this ("under"... 12-20-2013, 03:06 PM
Admin @ Ingolf please use code tags... 12-20-2013, 09:32 PM
Admin How would you decide which... 12-20-2013, 09:39 PM
jeff Hi A userform picks which... 12-21-2013, 08:17 AM
Admin Upload the userform. 12-21-2013, 12:18 PM
jeff Hi This code worked until... 12-21-2013, 01:06 PM
jeff The sheets have been added... 12-23-2013, 03:44 PM
Previous Post Previous Post   Next Post Next Post
  1. 12-20-2013, 03:06 PM #11
    Ingolf is offline
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    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