Input in cell will open file and copy values from it

[mirenoba]

Hello All,

I would like to ask you to help me with one issue. It is possible to creat macro/or more. Here is what i am looking for.

Example

I have file (workbook 1/sheet1) where i am scaning/writing code of part in column C:C after i scan/wrote number in C2 i want to automatically run macro that will open specific file(workbook2/sheet1) (link for this file is in cell D1) and copy last row area (A10:F10) from this file next to the C2 in workbook1/sheet1.

Its this possible? If necessary i can attache the files i am talking about. Thanks for help.

[ELeGault]

It is possible. You should try to build out your macro first and then I or someone here can elaborate on where to go from where you start. This will help with your learning as well as make it easier for us to understand where you are getting stuck so that we can better assist.

To get you started, This is the simplest code that I am aware of that will allow you to have a macro run based on cell update. You will need to add this to Sheet 1 of workbook 1. Make sure you replace the YourMacro with the name of the macro that you are using to call on Workbook 2, copy selection then paste to desired location. Again, make the sample workbooks and share so we can further assist.

Please Login or Register  to view this content.

[mirenoba]

Hello EleGault,

Sorry i didn't post what i already made. One issue is that macro open the file automatically but it is look like it is trying to open it twice. The part where i am really stuck and don't know how to proceed is to find last row in workbook 2 and copy it in workbook one next to the scanned code. If you need any more info let me know. Thanks for your support.

[mirenoba]

I made some progress the pasting part is working exactly as i want but the problem is copy part. Could someone fix the code so it will be copy last row in workbook 2 but only columns A:I?

Please Login or Register  to view this content.