Linking workbooks for automatic updates.

**BridgeCat** · 03-08-2012, 06:08 AM

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

**arlu1201** · 03-08-2012, 10:22 AM

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!

You can directly change the code from separating into worksheets to separating into workbooks.

**BridgeCat** · 03-08-2012, 10:53 AM

Thanks davesexcel! Attached is the sample workbook. Basically I want to pull each sheet to a different workbook.

Arlu1201 are you suggesting I can alter the code to filter out the data on close to different workbooks?

**arlu1201** · 03-08-2012, 11:31 AM

Yeah, instead of first exporting it to sheets and then to workbooks, you can directly export to workbooks.

**BridgeCat** · 03-08-2012, 07:35 PM

Hi Arlu1201,

I unfortunately do not know how to write that.

Please Login or Register  to view this content.

I am assuming I would have to change the copytorange:=Sheets(ce.Value) however am unsure of the wording. If we were looking at creating a sheet in C:/CE Value name sheet. Not idea what to do!