+ Reply to Thread
Results 1 to 5 of 5

Macro to move data fields?

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Macro to move data fields?

    Can I use a Macro that will move the completed project fields to a different worksheet automatically?

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro to move data fields?

    hi, FireMarshal, yes you can

  3. #3
    Registered User
    Join Date
    05-27-2011
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Macro to move data fields?

    Quote Originally Posted by watersev View Post
    hi, FireMarshal, yes you can
    That is great to hear Watersev! Can you share how to develop this macro? All columns of completed projects will be moved as the projects are completed. I assume I would SORT the data and block the section to be moved, but I need some help developing the Macro. Any help is appreciated!

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro to move data fields?

    post sample workbook showing original data and the result you need to obtain

  5. #5
    Registered User
    Join Date
    05-27-2011
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Macro to move data fields?

    Thanks again Watersev. I have attached the File. This is an Inspection Project Log where I schedule and monitor inspections. When completed (by Inspection date) I would like to sort amd move the selected data to another worksheet (yet to be made.) Any help would be appreciated!
    FireMarshal
    Attached Files Attached Files

+ 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