+ Reply to Thread
Results 1 to 6 of 6

Simple Copy/Paste Macro???

  1. #1
    Registered User
    Join Date
    04-24-2007
    Posts
    46

    Simple Copy/Paste Macro???

    I am a novice macro/vba user and I need to build a macro that simply copies and pastes certain columns of one spreadsheet into another. It will allow me to send "field copies" to my sales reps including only the information that they need or are authorized to have. I am sure this is basic macro programming but I am very new to it so any help would be appriciated. Thank you.

    KC Wright

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    May I suggest you record the actions and then post the code produced by the recorder. That way someone could write you some code to fit your requirements

    Note please ensure code is wrapped. See rules below for instructions

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    04-24-2007
    Posts
    46
    This is what I came up with. I am not even sure if it help. I will say this..... I have tried to trial and error my way through recording this macro and the main problem that I am having is when I "stop recording" and try to put the macro to use, it gets to the point of copying my first section and that's it. Again, I am sure it is simple to most of you but I am very new to macro recording. I am convinced that I am just doing something wrong with the basics.



    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-24-2007
    Posts
    46
    Here is a small portion of my spreadsheet. I really can not provide the whole thing due to confidential information. I probly shouldn't even attach what I have, but I really want to get this accomplished. Lets just say that I want to create a macro that will automate the copying/pasting of columns A, B, C, G, H, & J for each O'Reilly contact. What is the proceedure of recording these macros from start to finish? I get the general idea, I just think I am doing something wrong at the end of recording. I am sorry if I sound like I am VBA illiterate, but honestely, I am very new to it. Thanks for the help.... seriously.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-24-2007
    Posts
    46
    Further help is still needed. Thank you.

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sorry,

    Thought a VBA expert would have picked this up. Try something like

    Please Login or Register  to view this content.
    VBA Noob

+ 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