Can I group multiple spreadsheets to make universal changes?

[AndrewEdmunds]

I currently have 26 spreadsheets with financial data. The data is
identically alligned in each spreadsheet. The spreadsheets are too large to
have them all in the same spreadsheet with different tabs. Is there a way to
make changes (like adding a row or changing a heading) apply to all
spreadsheets without having to open each one individually and making the
changes.

 

[Bob I]

Please use terms Workbooks(a file) and Worksheets(spreadsheet in a file)
to explain your dilemma.

 

[Vijay Chary]

Hi Andrew !!
If you mean 'worksheet' by 'spreadsheet' then you
can put all 26 worksheets in one workbook. Use a Macro (See Excel's Help -
F1) to select all of them. Then make the changes you want only once, to have
the changes made to all 26 worksheets.

I'd like to hear from you when you've solved your
problem.

Regards

Vijay

 

[AndrewEdmunds]

Thank you both for your replies. By spreadsheet I meant workbook (File). I
cannot put all of the workbooks into one workbook on separate worksheets
because the file would be too big to work with. Is there anyway to make
changes to multiple workbooks at one time through some sort of grouping?

 

[Vijay Chary]

You can work with the 26 workbooks (files) with VBA code, quite comfortably
!

 

[AndrewEdmunds]

Thanks for your reply.

If I am understanding you correctly the only way to do this is through
visual basic code? So if I don't have visual basic expertise, I will have to
make the changes to each individual file?

Once again I appreciate all of your assistance.