Good Evening All,
I currently have 1 master workbook that has data inputed into it daily, all the cell/s information changes except for the headers. The 1st of 28 Headers is titled "Engine SN" and has the serial numbers of 58 engines automatically inputed once the raw data has been calculated from an external program. Each engine serial number has its own excel workbook. What i have to do know is cut and paste each row of the newly processed data into each of the 58 workbooks on a daily basis. Is there a way to have each of these workbooks automatically update each day with the new data from the master workbook? I need each update to add to the data that is already in each workbook, as that data is graphed and displayed elsewhere.
I have limited to no VBA experience.
I am currently using Windows 7 32Bit with Microsoft office 2013.
Thanks in advance
I currently have 1 master workbook that has data inputed into it daily, all the cell/s information changes except for the headers. The 1st of 28 Headers is titled "Engine SN" and has the serial numbers of 58 engines automatically inputed once the raw data has been calculated from an external program. Each engine serial number has its own excel workbook. What i have to do know is cut and paste each row of the newly processed data into each of the 58 workbooks on a daily basis. Is there a way to have each of these workbooks automatically update each day with the new data from the master workbook? I need each update to add to the data that is already in each workbook, as that data is graphed and displayed elsewhere.
I have limited to no VBA experience.
I am currently using Windows 7 32Bit with Microsoft office 2013.
Thanks in advance