auto updating info in multiple spreadsheets from one spreadsheet

[rayray21]

im trying to go paper less at work so im coming up with a more effencient method. We work around the clock and each lab tech files out a form like the one below and input all the data in to a database. then i at the end on the month run all these different quieries and copy and paist to another work book and make graphs out of the data. Im trying to delete all the mess around and make it one easy way to do it. below is a template that all the techs will be using from day to day and when they are done they will save as (date and name).

Is it possible to have the data save into different workbooks labeled for the different mills. For example when i type a result for Mill 3, 325, it will save in the mill 3 data and chart workbook i have set up. then the next time a 325 is entered it will save the new result underneath it, so on and so forth? and do that for each mill result i insert? i will upload a copy of data and charts later today i have to fix them they are to large.





MillSamples.xlsx

[arlu1201]

Do you mean to say that you have all the data in one workbook which should then be copied into its respective workbook?

Are all these destination workbooks stored in 1 particular folder?

[rayray21]

yes the workbooks i want to save in are in one folder. here are moch workbooks and i hope i did more explaining in them. Make sure you open all workbooks below to see what im talking about.i made note to what i am tring to explain.








mochMillSamples.xlsx
mochmill3.xlsx
mochmill4.xlsx
mochmill12.xlsx

[rayray21]

i hope those help you figure out what im talking about

[rayray21]

ant luck with figuring this out? can it be done or no?

[arlu1201]

Where will users fill in the data and how should the output be shown?

Will all the files be open at the time of running the macro or should the macro open it?

Do you want the output in a separate workbook?

[rayray21]

no the other books do not have to open just need it to save once it is inputted. and when another value is put in it saves underneath the one before so on and so forth. does this make sense?