export data to master workbook

[Sam_A_Rye]

Hi,

I'm a very new VBA user and have spent the better part of 2 day on this great website looking for a similar problem i've run into.

My problem is that i want information from "test" workbook~"results" worksheet to automatically update the "Tech Data" worksheet as well as export an update to the "Master" workbook.

FYI, two separate people input data: iron&manganese and Corrosion&scale inhibitor residuals. This data is exported to the 'results' worksheet and the same simple formula can be used to export to "tech data" worksheet. I am having a hard time getting the 'tech data' worksheet to export to the master workbook. I'm hoping someone can help me ensure the master file compiles all informaiton being exported to it. Note that the master file has several other headings as i was hoping to expand on the starter macro.

I created the tech data worksheet so data placement matched the master workbook format.

[Sam_A_Rye]

Hi, anyone reading this;

i've updated the workbooks and my problem. It seems that i cannot get the code to read from the current workbook that is opened but rather through a 3rd part workbook.

I'm using test1.xls (button "to master file") to send info from test.xls[tech data] to master.xls[tech data]

the problem i now face is;
1) i want to be able to sent directly from test.xls to master.xls
2) the data sent to master.xls is just copying the first line and not all present data.

i also want the "to tech data" button to only send data if an "LSD" exist (this code is not completed in the workbook, just started).

Thanks in advance,

Sam