Question
I have a master excel file Named Master shift log that every morning gets opened and then a save as is done named as the relevant day IE 10 and throughout the day the excel sheet is compiled with the date for the day to each machine being we have 40 machines and every morning having to transfer the last line of data to the Master shift log and save as again and start again
So, the question is, is it possible to somehow take the last line of date from the newly named sheet for each machine and place it in to the master document in the first line to the relevant machine this will save a lot of time of having to input the data manually then I can just do a save as and start again?
I hope this makes sense of what am trying to ask sorry i have never used macros or VBA's so don't know where to start.
I have a master excel file Named Master shift log that every morning gets opened and then a save as is done named as the relevant day IE 10 and throughout the day the excel sheet is compiled with the date for the day to each machine being we have 40 machines and every morning having to transfer the last line of data to the Master shift log and save as again and start again
So, the question is, is it possible to somehow take the last line of date from the newly named sheet for each machine and place it in to the master document in the first line to the relevant machine this will save a lot of time of having to input the data manually then I can just do a save as and start again?
I hope this makes sense of what am trying to ask sorry i have never used macros or VBA's so don't know where to start.