Macro with user defined inputs

[Nigel]

I have a worksheet with a list of cars, each row has basic info about a particular vehicle spread across 13 columns. If you click on a particular vehicle it hyperlinks to a seperate sheet containing far more info about that car. Potentially I have a list containing 250+ cars and therefore 250+ individual worksheets. My problem is some of the info on the main sheet is communicated from the vehicle specific sheet by named cells, and to set up 250+ cars each with 6 named cells will take forever. I have set up all the worksheets and temporarily matched the sheet name to the row it will relate to on the main sheet. Is it possible to have a macro which will work on a user defined row and a user defined worksheet so I can add the 6 named cells automatically?

[mrice]

If you look on my download page, you will find a macro which will list the individual sheets and their paths. This should generate 250 lines in column 1.

Then use a macro something like...

Please Login or Register  to view this content.

edited appropriately.

[mikerickson]

If your namedRange refers to =Sheet1!$A$1 , then namedRange will always point to sheet 1.

If otherNamedRange refers to =!$A$1 (the ! is important), then otherNamedRange will point to A1 of the sheet on which the name appears. This way of making named ranges relative with respect to sheet is one way to use named ranges with many sheets having a similar lay out.

Might this help you?