Hi All,
Basically i have a workbook containing macros that logs components going in and out of an oven, this spreadsheet is running on a pc in the manufacturing cell. However I want to be able to setup another PC in my office running the same spreadsheet so that I can see live what is being booked in and out.
I cant share the workbook because then the macros do not work properly. Is there a way I can do this? If not, is there some code that will interogate the spreadsheet and effectivly copy and paste the data into another workbook on a regular basis?
Thanks
Phil