1. Formula corrections across a range of files (standard layout) / 2. grouping worksheets from individual files into a master workbook / 3. printing t

[splash]

Hi all

I have 3 distinct issues that I would be very appreciative of your help with:

1. I have a large number of excel worksheets in a standard layout. I need to amend formulas in a particular column in all worksheets - is there a way to do this other than opening each workbook and amending the formulas manually?

2. These workbooks are saved in a number of folders within a network drive - is there a means to extract the information (numbers, format, layout etc) into a number of worksheets within a consolidated workbook - again, without doing this manually?

3. Once corrected I need to print each of these workbooks - can I do this without opening all the files individually?

Any help with any of these issues would be very much appreciated

Kind regards
Splash