Match and Macro Help Needed, I Think

[Keysha_bee]

Hi,
I have what I think is a pretty complicated task that I am trying to find a resolution to.

I receive a form like LTest from every sales order, I would like to copy certain data from LTest and copy it into 2016 Test 1. Each form is formatted the same and I want to use the data in cell B3 of LTest to select to proper tab in 2016 Test 1 and then insert the information in the corresponding cells of that same worksheet. One issues is LTest and 2016 Test 1 are different spreadsheets.

 

[oldbrewer]

are the forms electronic or paper
how many pieces of information are on form
are you saying every form has its own tab in 2016 test 1

 

[Keysha_bee]

the forms are electronic

I have 9 columns (A:I) and 28 rows

There are 3 tabs and the data in cell B3 will correspond with the name of one of the 3 tabs.

 

[Keysha_bee]

the forms are electronic

I have 9 columns (A:I) and 28 rows

There are 3 tabs and the data in cell B3 will correspond with the name of one of the 3 tabs.

Oldbrewer,
Did I give you enough information? Is this do-able?

Keisha