Selecting the same column as a button

[bbhockey]

Hello,

I have a loop that looks through a list of names, and compares the names to another list, then if it says yes or no, i want it to place yes in a column. I have column A for the name, and then columns D-H each have buttons on them that will look for a certain piece of info. My question is, what do i say in my loop that will place information that will always be in the row "i" (which initiates the loop as the row variable), and will place in the column where my button is? if this is confusing please respond and i will try to clarify.

Thanks

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[bbhockey]

I figured it out. Thanks for replying

[xladept]

You're welcome and thanks for the rep!