+ Reply to Thread
Results 1 to 3 of 3

Copy value in sheet 2 and paste in next empty cell in sheet 1

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    East Anglia
    MS-Off Ver
    2010
    Posts
    9

    Copy value in sheet 2 and paste in next empty cell in sheet 1

    Hi all, this forum has been of immense help to me this past year with work spreadsheets and I can normally search posts for an answer and edit it to suit my needs, the first time I decide to do something recreational I find I need a specific macro and although i can do basic formulas, macros are definately not something I grasp easily.
    I have created a golf syndicate score sheet that works out our handicaps from stableford score entry, for convenience I would like to enter player 1 score at cell A1 on sheet 2 and have that value paste automatically into the next available empty cell on sheet 1 column B after cell B7, once I have the code for the first player I will edit as necassary to bring the other 14 players scores in to play. Thanks in advance for any help given.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: Copy value in sheet 2 and paste in next empty cell in sheet 1

    try this:
    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-24-2015
    Location
    East Anglia
    MS-Off Ver
    2010
    Posts
    9

    Re: Copy value in sheet 2 and paste in next empty cell in sheet 1

    Hi alansidman, your macro works great for the first run and pastes the score from sheet2 A1 into sheet1 B8, but when I run the macro a second time, the score gets pasted at the bottom of the sheet in B140 instead of B10 which is the next blank cell. I need the macro to paste scores to the next empty cell in column B when run. ie B8, B10, B12, B14 etcScreeny.png
    Last edited by Locutos; 01-28-2016 at 03:49 PM. Reason: additional info

+ 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. [SOLVED] Copy And Paste on Another Sheet ( next time paste data from empty row )
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2014, 02:29 AM
  2. [SOLVED] Macro to Copy Range and Paste in the Empty Row Same Sheet
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-22-2013, 11:01 AM
  3. [SOLVED] Copy and Paste Row from Sheet(1) to First Empty Row in Sheet(2)
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 03:54 PM
  4. [SOLVED] Copy and paste row into next sheet, into next empty row??
    By Statesman in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-15-2012, 08:00 AM
  5. Copy rows until a empty cell and paste them into a new sheet or workbook
    By nkf531 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-05-2012, 06:27 AM
  6. Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8
    By fleeting in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2011, 03:31 PM
  7. Copy Entire Row & Paste in First Empty Row On The Same Sheet
    By Emonk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2011, 11:41 AM
  8. Copy Data & Paste Another Sheet Empty Row
    By johncena in forum Excel General
    Replies: 7
    Last Post: 03-02-2010, 07:47 AM

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