HOw to Paste links instead of Values in diffrent sheets

Hi friends,

i want to Link cells of different worksheets instead of copying the values or pasting

Please Login or Register  to view this content.

Would suggest posting a sample file. Based on original below might work. Not clear which index position sheet "A1" holds but we must presume somewhere beyond 12.

Would advise use Application.InputBox as it pre-validates data type.

Please Login or Register  to view this content.