Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Thank You Andrew Edmunds |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please use terms Workbooks(a file) and Worksheets(spreadsheet in a file)
to explain your dilemma. AndrewEdmunds wrote: 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote: 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. -- Thank You Andrew Edmunds |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? -- Thank You Andrew Edmunds "Vijay Chary" wrote: 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" wrote: 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. -- Thank You Andrew Edmunds |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can work with the 26 workbooks (files) with VBA code, quite comfortably
! :) "AndrewEdmunds" wrote: 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? -- Thank You Andrew Edmunds "Vijay Chary" wrote: 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" wrote: 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. -- Thank You Andrew Edmunds |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- Thank You Andrew Edmunds "Vijay Chary" wrote: You can work with the 26 workbooks (files) with VBA code, quite comfortably ! :) "AndrewEdmunds" wrote: 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? -- Thank You Andrew Edmunds "Vijay Chary" wrote: 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" wrote: 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. -- Thank You Andrew Edmunds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rename a group of spreadsheets in a workbook | Excel Discussion (Misc queries) | |||
Printing spreadsheets with values entered (group) | Excel Discussion (Misc queries) | |||
How do I eliminate Group on spreadsheets? | Excel Discussion (Misc queries) | |||
Can't print a group of spreadsheets Excel 2003 | Excel Discussion (Misc queries) | |||
Make A Universal Time Converter | New Users to Excel |