+ Reply to Thread
Results 1 to 5 of 5

Cut Paste data basis criteria

  1. #1
    Registered User
    Join Date
    03-26-2007
    Posts
    63

    Cut Paste data basis criteria

    I need to create a macro that will find the data basis criteria and then cut and paste the entire data into another sheet.

    Example the Sampel data attached contains a file. I would like to get a help on a macro that will Search for any occurance of word "Summary" in Sheet1 if found then from first low till that Summary ocuurance cut the entire data and paste it in new sheet. Then again start seraching for summary word if found again then cut the data from first row (remember this time it start picking data from next row of first summary occurance) till summary needs to cut paste in new sheet and so on. All the blank rows before first record needs to be deleted.

    If possible then name the new worksheets basis the summary type. for example first wud be "Summary Receivable" and second "Summary Payable".


    Thanks in Advance for any help if i can get onto it.

    Regards,
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Check out this thread with a sample workbook that has a few sample codes you can use,
    In the Module,
    Sub FindReplace()
    has an example of finding data, and pasting it some where else
    http://www.excelforum.com/showthread.php?t=631965

  3. #3
    Registered User
    Join Date
    03-26-2007
    Posts
    63
    The solution provided in the the given link is not applicable onto my issue. Appriciate any help if I can get on issue posted..

  4. #4
    Registered User
    Join Date
    03-26-2007
    Posts
    63
    Someone please help...

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Try this
    I was only able to get it to work with a helper sheet(Sheet2),
    The code will find all the words summary in sheet1, then run the macro to cut and paste the summary ranges to their own sheets.
    Paste the code below into a regular module, then run FindSummary macro

    Please Login or Register  to view this content.

+ 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