Re: Macro to copy worksheet to another workbook
Thanks john,
To answer your questions. The source workbooks will all have 2 worksheets. The file names will be consistent. I can put a checkbox on each worksheet to say if it is an original or an update.
Currently playing around with macros - do you happen to know how to paste something to the next free line of worksheet. Currently it is overwriting the first line every time i run it.
Thanks again