How could I find the next blank row and paste data in it in from a range of F4:M12. So if I enter data in cell J16 I am performing a vlookup and I'd like the return value to go to the next blank cell in range J4:J12. So if cells J4:J9 have data in it the result of the vlookup would go in cell J9.
Thanks in advance
Excel 2010
I'm having a difficult time understanding the requirement F4:M12 overlaps J4:J12. What are you looking up? A sample spreadsheet would help a lot.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Are you wanting to do this with just a formula or in VBA?
Can you also give a small example of the data set? Just enough so we will know what you are trying to accomplish?
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
So I am assuming you have a spreadsheet somewhere that has the sibling information listed since you refer to the vlookup kicking in. Is there a column that indicates the siblings are related? You can't just go on last name as there are often siblings with different last names. I am also assuming that if you select Billy for the Yankees and Jamie is added to the team, those 2 players should not be available for drafting on another team. What should happen if all the spots for an age group are filled when a sibling is chosen in a slot of another age. For example, lets say Billy is chosen in the 12 year old section, Jamie is his sibling but there are no more open 11 year old slots available. What should happen? What should happen if you have 2 siblings the same age? Should they go to the same team?
How are you envisioning this will work, with VBA code or with just formulas?
Sincerely,
Marty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Zimmerman 
Register To Reply
Bookmarks