Hello,
I am trying to create a system to track various criteria for individual employees who each have their own file.
The format and layout of these files are identical.
Changes are very likely in future; IE adding various SOP's & Policy sign offs.
I would like to have a master file to which I make any necessary changes, and then have those changes applied to every workbook in a directory. This will include any formulas which are likely to include Index, Match, Sumproduct functions.
These formulas reference a cell which already has the relevant information; extracted from the filename(s) themselves. (So changing this formula is unnecessary I hope!)
I had come across this thread
I'm very new to the VBA side of things and so I am hesitant about where I should begin making changes to suit my current problem.
Apologies if I have missed a thread which already answers this situation.
Thank you,
Kind Regards,
-R
I am trying to create a system to track various criteria for individual employees who each have their own file.
The format and layout of these files are identical.
Changes are very likely in future; IE adding various SOP's & Policy sign offs.
I would like to have a master file to which I make any necessary changes, and then have those changes applied to every workbook in a directory. This will include any formulas which are likely to include Index, Match, Sumproduct functions.
These formulas reference a cell which already has the relevant information; extracted from the filename(s) themselves. (So changing this formula is unnecessary I hope!)
I had come across this thread
VBA copying data from a master file to multiple workbooks and worksheets
Hello I am looking for help with a VBA code that copies data from a master file to multiple workbooks and worksheets. I can only find a code that does the opposite i.e. copy data from multiple workbooks to a master file. The Masterfile will contain 12 worksheets named p1, p2,…p12. Focusing on...
www.mrexcel.com
I'm very new to the VBA side of things and so I am hesitant about where I should begin making changes to suit my current problem.
Apologies if I have missed a thread which already answers this situation.
Thank you,
Kind Regards,
-R