Hi,
I haven't uploaded sample workbooks for the moment unless things get a little complicated and I need to. Basically I am working on a master workbook with a large amount of information for trainers conducting student training out in the field. I have filtered out each trainer into a separate worksheet in the same book, thanks to the help of a very helpful member on here!
From this "master book" I want to create a trainer file for each of them extracting out their worksheet. The reason for this is I want to control the information and just allow them to view it, without the risk of them corrupting the main sheet.
So in essense it would be something like
Workbook Master - sheet 1, sheet 2, sheet 3
Workbook 1 - Sheet 1 from Workbook Master
Workbook 2 - Sheet 2 from Workbook Master
Workbook 3 - Sheet 3 from Workbook Master
I seem to be able to do this by just linking the workbook in the cell and displaying data. However with over 16 columns and 100 rows I don't want to have to input into each cell the formula, it doesn't seem to want to let me drag down.
The other issue is I want it to auto update if the master sheet is edited and saved. Is this possible? Creating an on open macro event? If it would be easier for me to upload the worksheets to play with let me know.
Thanks
Bookmarks