+ Reply to Thread
Results 1 to 3 of 3

Cut and move data by macro (?) from one workbook to master workbook

  1. #1
    Registered User
    Join Date
    portland, OR
    MS-Off Ver
    Excel 2010

    Cut and move data by macro (?) from one workbook to master workbook

    Hi All,

    I am very novice with excel and macros so be kind... I am generating several workbooks to track samples that will be located in different freezers in my lab. I have assigned conditional formatting so that based on date, the color changes to show that a spot in a storage box is "filled" and then another conditional formatting so that once the word "disposed" is typed it will change to a different color. From here I may want the impossible... what I would like to have happen is once the color change for "disposed" happens is for all of the data in that cell to be cut and pasted into a seperate master disposal log (so we can track waste generated) and then have the now clear cell repopulate with the base info and conditional formatting so it's ready to go the next time we enter sample info. If the latter step makes it too complicated, then just having the data be cut and pasted automatically based on keyword would be awesome. Thanks for any help!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007

    Re: Cut and move data by macro (?) from one workbook to master workbook

    Why dont you attach a sample copy of your file?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)

    Re: Cut and move data by macro (?) from one workbook to master workbook

    A simple non-programming way to achieve what you want, is to have your master disposal log reference all entries in your "data" file, and then to add a filter to both files. In you data file, filter out all the "disposed" references, and you will be left with stuff thats still there. In the master file, filter out everything thats not disposed.

    I know this will mean that both files will continue to grow as data is added, but this will work for you until some1 gives you the VB code for a more eligant solution
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


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