In the following pic you see a Save and a Search button.

\1

These buttons are assigned to macro's. When I press the Save button the current document will be saved as 123456.xls because it saves as the value located in cell F10. This file is saved in the map shipments which is located on a shared directory. I save multiple files in this map which all have a unique number attached to it.

Now when I want to recall any of those files I use the Search macro. Under the field of the Search button I can fill in one of the unique numbers and it will open the file. Suppose I typed in 123456.xls it will look like this.

\1

Now instead of opening the files next to my original Receipt Note I - MRN BP.xls I would like to implement the following idea.

When I fill in 123456 in the Search field and press the Search button it should copy the data from the 123456.xls file and paste it in the original Receipt Note I - MRN BP.xls It must only copy paste the data from the following cells:

F2-F11
B13-B16
F13-F16
H13-L16
F18-F25
H18-M25
F29-F34
F40-H41
F43-F44

Here you have the macro's I use at the moment.

Please Login or Register  to view this content.
Please Login or Register  to view this content.
Thanks in advance for your time