Find cell based on word in cell

[bobkap]

Using a VBA macro, I need to find the cell that is one cell below the cell with the word "Qty" in it. Here's the link to my file as an example. Any help would be greatly appreciated.

Quote page.xlsm

Shared with Dropbox

www.dropbox.com

 

[6StringJazzer]

We need to clarify your requirement just a bit.

What do you mean "find" it? What do you want the macro to do with that information once it finds it?

Isn't it always going to be the same cell all the time $C$17?

 

[bobkap]

We need to clarify your requirement just a bit.

What do you mean "find" it? What do you want the macro to do with that information once it finds it?

Isn't it always going to be the same cell all the time $C$17?

Thanks very much for asking! I was concerned about hard-coding C17 but now that I think about it, it will be highly unlikely that that will ever change. With that said, I guess I know what to do now. Thanks again for getting me to think more about this.

BTW, I play guitar too. I just added to my collection a Fender Tele Acoustasonic.

 

[smozgur]

With that said, I guess I know what to do now.

That would be great if you could let us know what to do, so future readers of this question might also find it helpful. Then it is perfectly fine to mark your own post as the solution.

By the way, if @6StringJazzer's suggestion is the solution itself, as it looks like to me, then I would mark that post as the solution.