I would like to write a vba script which will trigger a hyperlink to a range of cell(3 columns) in a sheet, and have the range of cells in columns A,B and C, starting at A3.
So this is my problem: For production Control, I have 3 sheets(Input, Data, and Downtime), I choose machine type in Input sheet(say LineA, LineB, and LineC), I have already got a macro that will paste the values from Input to data sheet, but I want to see the downtime reasons for a particular line, depending on line chosen in Input sheet. This is done using a drop down list. I would like to see the downtime reasons for the chosen Line when I open the Downtime Sheet.
Looking forward to hear from you.
Thanks for your input.