Make selection and fill information

[ted1234]

I want to select any and only one fruit from an excel file, and once that selection is made, the fruit name along with its information gets assigned to a code next in line in a different excel file and those cells fill themselves with that information. Once that is done, the code # gets printed in the original excel file beside the fruit that was selected.

Images are below:

Capture1.PNG
Capture2.PNG

The VBA code to make the selection is already been written, so don't worry about that. FYI that code is:

Please Login or Register  to view this content.

[Bernie Deitrick]

Something like this - change the filename and sheet name: the other file must be open for this to work

Please Login or Register  to view this content.

[ted1234]

Something like this - change the filename and sheet name: the other file must be open for this to work

Please Login or Register  to view this content.

I appreciate you doing the code. It works perfectly. However, it didn't help me as I expected. The content I have is not as organized in the file, so I am assuming the code needs to be changed a little. Please see the images below:

Capture3.PNG
Capture4.PNG

Top image: The user needs to select one of the three files (File1, File2, or File3). The user selected file opens automatically
Bottom image: Then whatever next row is blank in that file, the user entered information length, width, and height from the first file fills out, and gives back the code# in the first file.

[Bernie Deitrick]

So you want the number 2 returned - but to where? A specific cell, or list starting in a cell and extending down a column?

Are File1 File2 and File3 actual file names? Where are the files stored? What are their full names?

[ted1234]

So you want the number 2 returned - but to where? A specific cell, or list starting in a cell and extending down a column?

Are File1 File2 and File3 actual file names? Where are the files stored? What are their full names?

File1.xls
File2.xls
File3.xls

The files are actually in one of the folders in my C: drive.

For example: Let's say I select the yellow highlighted cell beside File2, so there is a check mark in there, and as a result File2 opens. Now, the length, width, and height of 12,20,5 (these cells should be initially blank), respectively will be automatically copied beside code 3 line because that's the next empty row. After that, the code # 3 will be copied in the original file beside the bold word "Code".

[Bernie Deitrick]

Please Login or Register  to view this content.

[ted1234]

Please Login or Register  to view this content.

That one works perfect. Awesome!
What if I want to select specific sheet in the file. For ex: In the image below if I select File1, then I must also select which sheet I want such as Sheet1 or Sheet2.

Capture5.PNG

[Bernie Deitrick]

Try it like this, without columns G and H:

Please Login or Register  to view this content.

[ted1234]

What if I have File2 and File3 in a different location such as the X: drive?

[ted1234]

Try it like this, without columns G and H:

Please Login or Register  to view this content.

I just realized that I actually didn't need to worry about the sheets, but rather having the files in different locations. I apologize. What if I have File2 and File3 in a different location such as the X: drive?

[Bernie Deitrick]

Put the drive into another cell - say, to the right of the cells that you are clicking on, and change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Enter the full path (but without the final \ ) into those cells.

[ted1234]

Put the drive into another cell - say, to the right of the cells that you are clicking on, and change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Enter the full path (but without the final \ ) into those cells.

Perfect! Thank you so much. I really appreciate all your help. I think I am going to try to learn Excel VBA.