Posts by flemmo

Thanks Ralph - That is perfect.

BTW I cleared out the rest of the sheets, just didnt do it on Main.

Thanks again
Adrian

Hi guys,

Thanks for your replies so far and apologies for posting in the wrong place.

I have included a (cut down) version of the file I am working with.

What I am trying to acchieve is a mechanism for clicking on the part number in the sheet "main" which then copies the data in that part number cell to cell A7 in the sheet called "item details" so that the rest of the sheet can gather the rest of the details.

I want to stay away from anyone having access to the sheet called pricelist as it is very ugly and not user friendly. I have set up an incremental counter to use the VLOOKUP to retrieve the data from this sheet so there really is no way I can just reference somthing that is already there.

Any ideas?

Hi all,

I am looking for a way to have a list of part numbers have a "button" style approach to a more detailed version of each part - to include descriptions, inclusions etc.

I have been trying to get a hyperlink to work, but I cant seem to find a way to get the hyperlink to pass on the data in the cell to another worksheet so I can use this to source the other relevant bits n pieces.

Can this be done or does someone have an alternative method?

Cheers