I have a number of template worksheets that people enter data into in
contained in several workbooks. What is the best way to make changes to
these templates for necessary updates all at once like adding a cell w/ data
validation or a row of information etc.. I have used the Group function to
try and do some of this but it does not work for everything and is somewhat
tedious.

Do folks typically develop Macros to do this?? If so are there any examples
out there of some typical Macros to address this.

Hi Lee,

Will you be making the same change to every workbook?

If so, code exists to open everywork in a folder, call another macro (which
will make the changes you want) save, close and move onto the next one.

Thanks,

Simon

Lee wrote:
I have a number of template worksheets that people enter data into in
contained in several workbooks. What is the best way to make changes to
these templates for necessary updates all at once like adding a cell w/ data
validation or a row of information etc.. I have used the Group function to
try and do some of this but it does not work for everything and is somewhat
tedious.

Do folks typically develop Macros to do this?? If so are there any examples
out there of some typical Macros to address this.

Each workbook for each team contains several different types of forms each
form is on a worksheet. Each team enters unique information on each
form/worksheet. There are multiple copies of the same form/worksheet within
a workbook. If the form changes I would like to be able to update it and
carryover the existing information without having to retype it in. The cell
location of where the information is contained will not change.

"smw226" wrote:

Hi Lee,

Will you be making the same change to every workbook?

If so, code exists to open everywork in a folder, call another macro (which
will make the changes you want) save, close and move onto the next one.

Thanks,

Simon

Lee wrote:
I have a number of template worksheets that people enter data into in
contained in several workbooks. What is the best way to make changes to
these templates for necessary updates all at once like adding a cell w/ data
validation or a row of information etc.. I have used the Group function to
try and do some of this but it does not work for everything and is somewhat
tedious.

Do folks typically develop Macros to do this?? If so are there any examples
out there of some typical Macros to address this.

Lee,
If this is going to happen often, you could set up a Macro that you could
modify to use when required. Easiest way to get started is just to record
some dummy macro, making sure to place it into your Personal Macro workbook
(created by Excel - personal.xls) Do something simple like start recording a
macro, select another cell, stop recording, then use Tools | Macro | Macros,
select the one you recorded and choose [Edit]

Then you could modify the code in it to something similar to this:
Dim anySheet as Worksheet
For Each anySheet In ActiveWorkbook.Worksheets
anySheet.Range("B55") = "New Entry for cell B55"
anySheet.Range("G99") = 3.14159 ' put pi into G99
Next

Once you've made the edits to the macro that you need to, you open each
workbook that the changes need to be applied to and simply run that macro.
Remember that macros are very literal minded, so in this case, those changes
would be written to every worksheet in the active workbook. If there were
sheets you did not want the changes made to, you could add some exception
handling to it like:

For Each anySheet In ActiveWorkbook.Worksheets
If anySheet.Name < "Not Me" And anySheet.Name<"Me Either" Then
anySheet.Range("B55") = "New Entry for cell B55"
anySheet.Range("G99") = 3.14159 ' put pi into G99
End If
Next

And sheets named "Not Me" and "Me Either" would be skipped.
"Lee" wrote:

Each workbook for each team contains several different types of forms each
form is on a worksheet. Each team enters unique information on each
form/worksheet. There are multiple copies of the same form/worksheet within
a workbook. If the form changes I would like to be able to update it and
carryover the existing information without having to retype it in. The cell
location of where the information is contained will not change.

"smw226" wrote:

Hi Lee,

Will you be making the same change to every workbook?

If so, code exists to open everywork in a folder, call another macro (which
will make the changes you want) save, close and move onto the next one.

Thanks,

Simon

Lee wrote:
I have a number of template worksheets that people enter data into in
contained in several workbooks. What is the best way to make changes to
these templates for necessary updates all at once like adding a cell w/ data
validation or a row of information etc.. I have used the Group function to
try and do some of this but it does not work for everything and is somewhat
tedious.

Do folks typically develop Macros to do this?? If so are there any examples
out there of some typical Macros to address this.