+ Reply to Thread
Results 1 to 7 of 7

Need Fast Copy Macro

  1. #1
    Registered User
    Join Date
    09-02-2020
    Location
    Austin Tx
    MS-Off Ver
    2016
    Posts
    4

    Need Fast Copy Macro

    Hello,

    I am doing high volume of copying and pasting, hundreds of copys and pastes at a time.

    Basically I am copying data from one screen to an excel spreadsheet on a neighboring and spending alot of time moving the mouse back and forth.

    What I need is a macro so that I can stay on the screen I am copying data from and use a macro to paste it in the appropriate place. Each paste needs to be exactly one column to the right of the previous paste. This way I can just highlight data, hit the macro and then highlight the next set of data.

    For example: Highlight data set 1 on original screen, paste into excel cell A1. Highlight data set 2, hit macro and it automatically pastes into cell B1. Highlight data set 3, hit macro and it automatically pastes into cell C1. This will continue for hundreds of data sets.

    Potentially irrelevant but each data set will have 20+ rows of information. These however naturally go into place with manual pasting. The pasting needs to merge formatting as well.

    Thanks for the help,
    Tanner Worthington
    Attached Files Attached Files
    Last edited by tworthington; 09-02-2020 at 11:28 AM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,779

    Re: Need Fast Copy Macro

    Yes it can be done. Please provide an example file as per the yellow banner above so we can assist you further

  3. #3
    Registered User
    Join Date
    09-02-2020
    Location
    Austin Tx
    MS-Off Ver
    2016
    Posts
    4

    Re: Need Fast Copy Macro

    Added. My apologies, this is my first time using this forum. I really appreciate all the help. This will save me hours at work.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,625

    Re: Need Fast Copy Macro

    You mention copying data from one 'screen' to a worksheet. Can you be more specific.
    For instance do you have several workbooks open in memory and you want to select each in turn and then do the copy paste stuff?

    If so please upload a couple of examples of the workbooks from which you copy.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,779

    Re: Need Fast Copy Macro

    To add to Richards question, do you want to always paste into A1 of the new sheet and have the full range of existing data on the new sheet to move by one column to the right? You could rt click and select 'insert cut cells' on Column A header and that will move all columns to the right. Is this what you are trying to achieve? We may be able to automate these individual copy/paste steps into one step for all your data if we could see your original source of data.

  6. #6
    Registered User
    Join Date
    09-02-2020
    Location
    Austin Tx
    MS-Off Ver
    2016
    Posts
    4

    Re: Need Fast Copy Macro

    Either way will work. The order of the columns is irrelevant. I just would prefer to not have to click back over to excel. I am copying straight off a web browser and could save a lot of time if I didn't have to maneuver my mouse back to excel to the appropriate cell.. I am using a web based information tool which gives me data on people. I work in sales and part of my job is building lists of potential prospects.

  7. #7
    Registered User
    Join Date
    09-02-2020
    Location
    Austin Tx
    MS-Off Ver
    2016
    Posts
    4

    Re: Need Fast Copy Macro

    I am copying data of a web browser on my main screen onto the excel spread sheet which is on the second screen. 1 website, 1 excel workbook, 2 monitors.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fast copy sheet from closed workbook
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2020, 02:19 AM
  2. Macro running too fast
    By LLL0422 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2014, 01:16 PM
  3. If + vlookup function, fast way to copy paste?
    By fetow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2014, 06:45 AM
  4. [SOLVED] fast VBA copy to range?
    By Oppressed1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2013, 11:17 AM
  5. [SOLVED] fast copy and paste not transferring blank cells
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2013, 03:15 PM
  6. Replies: 3
    Last Post: 03-22-2010, 12:29 PM
  7. [SOLVED] fast range copy (without clipboard and with formatting)
    By Max Belugin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2005, 10:05 AM

Tags for this Thread

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