Results 1 to 5 of 5

VBA to paste data in next availble blank row within a range.

Threaded View

  1. #4
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: VBA to paste data in next availble blank row within a range.

    This is just a sheet that is used fro baseball drafting. In cells F4:M12 is data validation lists of all the kids who are 11 years old. The columns are the actual teams. So there are a total of 9 teams. In cells F13:M19 are data validation drop down boxes as well but these are of 12 year olds. So what I'm trying to accomplish is if I choose a player that is 12 years old (in cell J16) and they have a younger brother who is 11 the vlookup kicks in and will return the 11 year old brothers name in the next available blank cell (in this scenario in cell J9 since cells J4:J8 have a name in it already) in that same row. Attached is a sample file
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy only non-blank cells in range and paste to new range.
    By scrabtree23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2015, 08:10 PM
  2. [SOLVED] Macro to copy and paste new data into the next blank cell WITHIN a range
    By MattRNR in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 10-22-2015, 12:45 AM
  3. Find Date Range data's and paste the next sheet blank row.
    By rskfriends in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 03:41 AM
  4. Paste range at first blank row
    By mumsys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2013, 04:36 AM
  5. Replies: 4
    Last Post: 03-17-2013, 05:58 AM
  6. Enter text value into next availble cell in range if user selects correct answer
    By jerbaldw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 10:24 AM
  7. [SOLVED] Object not availble onthis machine.
    By Kjeldc in forum Excel General
    Replies: 0
    Last Post: 08-08-2005, 02:07 PM

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