+ Reply to Thread
Results 1 to 3 of 3

Copy selected data to Workbook on Desktop

  1. #1
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Copy selected data to Workbook on Desktop

    Greetings, Gurus.

    I've been trying to cobble together a macro from snippets of other macros I found doing searches on thsi site, but have so far been unsuccessful.

    Here's what I'm trying to do:

    As the buyer edits orders, I have a macro which pulls out all the parts with changes and puts them on a sheet named "Changes" in the attached "Sample" workbook. Since the buyer will do dozens of these edits a day, I'm trying to create a simple way for them to create a list of parts they may want to try and buy from another source.

    I would like to add a macro that would open a message box telling the buyer to select the parts they want to copy. They could select whatever rows they want to copy to the "Backorder List", and select "OK" or hit "Enter", and the macro would open the workbook named "Backorder List.xls" on their desktop, (mine is located under "C:\Documents and Settings\jerry.hutcheson\Desktop"), and copy the selected rows to the workbook, then save changes and close the "List" workbook. It should only paste the values, to preserve whatever formatting is in the book being copied TO, and it should copy below any data already in the workbook.

    To make things even more difficult, the macro would also need to copy the Vendor # and PO # from the top of the "Sample" workbook, (cells B2 and B3 respectively), and enter that data beside the other data just pasted beside the parts data in the backorder list. (I have entered sample data in the backorder list to show what I mean.)

    Is this something that can be done, or am I dreaming here?

    Thanks in advance for any help you can offer.
    Attached Files Attached Files
    Last edited by hutch@edge.net; 10-14-2009 at 11:17 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Re: Copy selected data to Workbook on Desktop

    I get it. You guys are like my algebra teacher in high school. I'll get a lot more assistance if I show my work.

    Okay, here's what I've got. It's probably not pretty, but it works all the way down to where I try to copy the PO # and Vendor # down the sheet, (highlighted in Red):

    Please Login or Register  to view this content.
    Again, thanks in advance for any help you can offer.

  3. #3
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Re: Copy selected data to Workbook on Desktop

    I got it. The syntax I was looking for was:

    Please Login or Register  to view this content.
    Have a good one.

+ 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