Inputbox query

[robcarr]

Dear All,

You may have noticed I post a few questions, only because you all give such good advice, so yet again I am asking another question,
I would like an inputbox to open up in my code and whatever name I type in this box it will find the name and then I would like it to copy all the data in a block below this word, the word always appears at the top left of the block of data. The word I am searching for changes regularly so I need to have a way for the user to input the word instead of me trying to change the code each month. I tried to do this, but am quite new to this and cant really get my head around it.

Thanks again for all help.

 

[DaleWatson123321]

Hi again,

This is a "roughing out" of one possible method...

1) You could have an InputBox in your code, or you could create a ComboBox on the sheet, from which the user will pick ONE name.

2) This name will represent a range name assigned to one of the blocks of data.

3) Once selected, your code would copy the block of data defined by the range name.

I hope this helps. If you need further assistance, please advise.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca