Cell Reference Selected Workbook

Right now I am using the below code to select a different workbook and put data in different cells. Is it possible to have the pasted cells become references instead of just copy/paste. I would like this workbook to continue to update when the other workbook has been updated.

Please Login or Register  to view this content.

pls try to change your code

Please Login or Register  to view this content.

as below

Please Login or Register  to view this content.

Originally Posted by wk9128

pls try to change your code

Please Login or Register  to view this content.

as below

Please Login or Register  to view this content.

So this worked, but makes the sheet name "Original". Can it select either sheet(1) or ActiveSheet? There is only one sheet in the workbook.

pls try this code

Please Login or Register  to view this content.

Originally Posted by wk9128

pls try this code

Please Login or Register  to view this content.

I figured it out. There was a hidden sheet that I didn't know was there and I was getting an error. The original code worked! Thank you!!

@kasermap You're Welcome. Glad to help . Thank You for the feedback and rep.