Fill in answer in first blank cell available

**souljive99** · 08-13-2009, 11:04 AM

Hi All,

I would like to create a macro that takes the result from one cell, and puts it into the first available blank cell in another document (A1). The next result I get, I would like it to automatically go in the next blank cell (A2) and so forth. Can anyone help me with this?

Thanks.

**stanleydgromjr** · 08-13-2009, 11:37 AM

souljive99,

Please post your workbook (or a sample) - scroll down and see "Manage Attachments".

**JBeaucaire** · 08-13-2009, 11:37 AM

Something like:

Please Login or Register  to view this content.

**royUK** · 08-13-2009, 11:46 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**souljive99** · 08-13-2009, 11:59 AM

Hi,

I'm not sure how to make the thread title any clearer - I want a result to be filled into the first blank cell that is available. I apologize if that is not clear. Here is an example of what I am looking to do. I want to take what is filled in in the Sample Input Page and have it put in the first blank row in the Sample Results page, without deleting any of the other information that is already there.

Thanks.