changes to the same worksheet within multiple files

I have a master workbook that has 9 different workseheets 
in it.  The master has been saved to over 200 files.  
Certain things need to be changed within the 200 files on 
certain worksheets.  Is there any way to make changes to 
ALL 200 sheets at one time, aside from a macro, or 
changing each affected worksheet individually?
0
anonymous (74722)
4/29/2004 1:03:54 PM
excel.misc 78881 articles. 5 followers. Follow

6 Replies
352 Views

Similar Articles

[PageSpeed] 29

AFAIK you would have to use a looping macro to open each workbook>make the
changes>save & close.

-- 
Don Guillett
SalesAid Software
donaldb@281.com
<anonymous@discussions.microsoft.com> wrote in message
news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
> I have a master workbook that has 9 different workseheets
> in it.  The master has been saved to over 200 files.
> Certain things need to be changed within the 200 files on
> certain worksheets.  Is there any way to make changes to
> ALL 200 sheets at one time, aside from a macro, or
> changing each affected worksheet individually?


0
Don
4/29/2004 1:09:49 PM
You need a macro

Look at this example
http://www.rondebruin.nl/copy4.htm


-- 
Regards Ron de Bruin
http://www.rondebruin.nl


<anonymous@discussions.microsoft.com> wrote in message news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
> I have a master workbook that has 9 different workseheets
> in it.  The master has been saved to over 200 files.
> Certain things need to be changed within the 200 files on
> certain worksheets.  Is there any way to make changes to
> ALL 200 sheets at one time, aside from a macro, or
> changing each affected worksheet individually?


0
rondebruin (3790)
4/29/2004 1:10:22 PM
Thanks Ron, I appreciate it!
>-----Original Message-----
>You need a macro
>
>Look at this example
>http://www.rondebruin.nl/copy4.htm
>
>
>-- 
>Regards Ron de Bruin
>http://www.rondebruin.nl
>
>
><anonymous@discussions.microsoft.com> wrote in message 
news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
>> I have a master workbook that has 9 different 
workseheets
>> in it.  The master has been saved to over 200 files.
>> Certain things need to be changed within the 200 files 
on
>> certain worksheets.  Is there any way to make changes to
>> ALL 200 sheets at one time, aside from a macro, or
>> changing each affected worksheet individually?
>
>
>.
>
0
anonymous (74722)
4/29/2004 4:19:19 PM
Thanks Don, I appreciate it!
>-----Original Message-----
>AFAIK you would have to use a looping macro to open each 
workbook>make the
>changes>save & close.
>
>-- 
>Don Guillett
>SalesAid Software
>donaldb@281.com
><anonymous@discussions.microsoft.com> wrote in message
>news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
>> I have a master workbook that has 9 different 
workseheets
>> in it.  The master has been saved to over 200 files.
>> Certain things need to be changed within the 200 files 
on
>> certain worksheets.  Is there any way to make changes to
>> ALL 200 sheets at one time, aside from a macro, or
>> changing each affected worksheet individually?
>
>
>.
>
0
anonymous (74722)
4/29/2004 4:19:47 PM
Ron,

You are the BEST!!!  Quick question, once I set up the 
macro and perform the needed changes, if I "deep six" the 
macro, will the changes hold?  I don't want users to be 
involved with the macro.
>-----Original Message-----
>Thanks Ron, I appreciate it!
>>-----Original Message-----
>>You need a macro
>>
>>Look at this example
>>http://www.rondebruin.nl/copy4.htm
>>
>>
>>-- 
>>Regards Ron de Bruin
>>http://www.rondebruin.nl
>>
>>
>><anonymous@discussions.microsoft.com> wrote in message 
>news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
>>> I have a master workbook that has 9 different 
>workseheets
>>> in it.  The master has been saved to over 200 files.
>>> Certain things need to be changed within the 200 files 
>on
>>> certain worksheets.  Is there any way to make changes 
to
>>> ALL 200 sheets at one time, aside from a macro, or
>>> changing each affected worksheet individually?
>>
>>
>>.
>>
>.
>
0
anonymous (74722)
4/29/2004 7:22:55 PM
Hi

The users don't see the macro
The macro is in the master workbook

You copy a range or sheet from the master workbook to all workbooks
and save each workbook in the loop with this line

mybook.Close True



-- 
Regards Ron de Bruin
http://www.rondebruin.nl


<anonymous@discussions.microsoft.com> wrote in message news:60d201c42e1f$5f7a4910$a401280a@phx.gbl...
> Ron,
>
> You are the BEST!!!  Quick question, once I set up the
> macro and perform the needed changes, if I "deep six" the
> macro, will the changes hold?  I don't want users to be
> involved with the macro.
> >-----Original Message-----
> >Thanks Ron, I appreciate it!
> >>-----Original Message-----
> >>You need a macro
> >>
> >>Look at this example
> >>http://www.rondebruin.nl/copy4.htm
> >>
> >>
> >>-- 
> >>Regards Ron de Bruin
> >>http://www.rondebruin.nl
> >>
> >>
> >><anonymous@discussions.microsoft.com> wrote in message
> >news:5fef01c42dea$6c8e7890$a001280a@phx.gbl...
> >>> I have a master workbook that has 9 different
> >workseheets
> >>> in it.  The master has been saved to over 200 files.
> >>> Certain things need to be changed within the 200 files
> >on
> >>> certain worksheets.  Is there any way to make changes
> to
> >>> ALL 200 sheets at one time, aside from a macro, or
> >>> changing each affected worksheet individually?
> >>
> >>
> >>.
> >>
> >.
> >


0
rondebruin (3790)
4/29/2004 7:45:45 PM
Reply:

Similar Artilces:

send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with one or two fields changed (for example the name of recipient and the date).How canthis be done?? I would also like to be able to save the e-mail and use it again and again. can anyone help cheers john If you have Word installed and it's the same version as Outlook (both 2003, for example), you can do a mail merge between the two. This would allow you to set up the text the way you want it to, and you can save the document for future use. Look at the following page for further information: http://www.slipstick.com/con...

Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening, closing, copying files, see: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.misc&mid=1fe358b1-c8eb-4217-ad2a-4b9fcf741916 A better solution is offered at http://support.microsoft.com/kb/918165 "Problems in Windows Explorer or the Windows shell after you install security update MS06-015". Patricia Shannon wrote: > If you have installed a Windows update and started having problems opening, > closing, copying files, see: > > http://ww...

Fax Icon on my File menu and toolbar
I had a Fax Icon on my toolbar and also on the file menu. All of a sudden it is gone and I want it back. Where did it go? Was it a dedicated toolbar? Or was it just icons on a builtin toolbar? If it was a dedicated toolbar, you may get lucky and find it under: Tools|customize|toolbars tab (just not selected) But if it was on a builtin toolbar (along with the file menu), then maybe you reset your toolbar--also under: Tools|customize|toolbars tab selecting a toolbar and hitting the reset button. If that's what happened, I think I might try to find the Fax addin/workbook that added t...

exporting outlook 2000 pst files to a database
I need to export outlook 2000 to a database- attachments and all. Is there a simple way to do this so you can search and retreive messages and attachments in a database form? Thanks Jeff You can export individual folders to access or excel to have them available for searching. I have never tried to export my entire .pst file to access or excel however. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After searching google.groups.com and finding no answer Jeff <laacid@yahoo.com> asked: | I need to export outlook 2000 to a database- ...

double worksheets?
A co-worker was working in a regularly-used workbook. Suddenly a second, seemingly identical workbook opened; the two were named *.xls:1 and *.xls:2 respectively. A week ago, a similar situation happened with the same workbook, except the duplication occured upon opening, rather than after it was already open. At that time, when we closed one of the "versions" the colon-number additional extention disappeared. But after closing the remaining document and reopening, the duplication appeared again upon opening. Can anyone tell us what this means? Did she accidentally hit a comman...

why does sorting change a scatter plot graph?
Why does the way a spread sheet is sorted change the look of a scatter plot graph??? the graph is just a plot of two points, (X, Y) and these two points are definded by two collumns for a given row. The two collumns don't change, and the row all stays together, so why does it change where points are plotted out on the graph when you re-sort it? AndrewT420 - Usually, for an XY (Scatter) chart, with values of X in a column and corresponding values of Y in an adjacent column, for three or more points, Excel assumes (correctly) "Series in Columns." But, when you have only...

office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified and saved to only yesterday [Office 2000] a window pops up with: "name.xls cannot be accessed. The file may be resd-only, or you may be trying toaccess a read only location. Or, the server the document is stored on may not be responding." Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette are accessed with no problem. This is on a network drive? ...

Worksheet Auto update
I need to find a way to automate a process. Is there a way to automatically replace the content of a worksheet with the content of another one? Every morning I get a sales report in excel for the previous day sales. I save it in a folder and then I do a pivot table on this sheet to determine sales by product category for example. The following day, I open the previous day file, replace the sales report with the new one and then refresh my pivot table. Is there a way to have my sales report update anytime I get a new sales report? To be more clear I have a workbook with two tabs: Pivot...

Changing Prices in HQ.
Hi, I have this little issue. I want to change the put items on promotion using the price wizard using HQ. Unfortunately if I have stores who has differents prices for a same item the wizard do not make the proper change becuase it use the price already stored in the master table. Does anyone saw this issue before? Who was solved?. Thks in advance for your help. Rgds Rodrigo Hi there, The easiest way to look after this is to not change any data on the ITEM in HQ, but to simply do the worksheet for altering the sale price and then send it to the respective stores. Then in the works...

Content of emails is changing without any reason !
Hallo I changed operating system last week. From Win XP to Win 7. Used to work with Outlook Express at full satisfaction. I could transfer most of my emails automatically with export/import features of Microsoft software. But I suddenly discover 1 very big problem (bug ???) I am used to work with several maps, and hereby go to several levels deep. Such as : Saved mails Companyname Projectname Date of action Department Activity Name of patient Different emails So sometimes maps can go several levels deep. When I check ema...

multiple email identities
HELP! My husband and I share the same computer and we have our email come to our inbox through Microsoft Outlook. However it is merging our accounts- how do we seperate into 2 identities so we each get our own mail! It is so frustrating! Please help! Thanks Kat Outlook does not use Identities - it uses profiles. See this page for more information: http://www.slipstick.com/outlook/share.htm --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the Swen virus, all e-mails sent to my actual account will be deleted w/out reading. After s...

Outlook receiving zip files
Why is it when I try to send zipped files to my address; it gets returned as service unavailable? Hello Omar, your Exchange dont allow you to send this! Please speak with your Domain Admin "Omar" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag news:0754E7DA-31DC-4966-9FC1-C290A8D8222C@microsoft.com... > Why is it when I try to send zipped files to my address; it gets returned as service unavailable? Hi Omar, your Provider don�t supportet this part of file! -- Gestern lief noch alles, ich habe nichts gemacht! Bitte in der Newsgroup antworten, damit jeder d...

Saving toolbar changes
After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always defaults to its own toolbar settings. This makes toolbars almost useless. How can one insist that PPT use YOUR toolbar setting, rather than its own default Thanks. Hi Jeff, If I have a lot of tool bar changes to make, I close all the workbook that are not hidden then unhide my personal.xls from the Window menu. I don't know why...

Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching forever and havn't found a hint yet. I have multiple domains setup on my exchange server. Lets say abc.com, def.com, and hij.com. We only send email with @abc.com but can receive from any domain name. Recently we merged with another company and we brought back their email to our server, lets say xyz.com. Now I configured a new recipient on Exchange 2003, so I now have two policies. The first policy has the three original domains in it with @abc.com as the primary domain. In the second policy I have configured xyz.com t...

unable to read file #7
Does anyone know how to solve this error? This is the second time I have had the same error on the same file. Last time I was able to recover from a saved copy and updated fine. This time whenI opened the copy and updated it, then saved it, I got the same error when I tried to open it again, Now I don't have a good copy. I have downloaded all avaliable updates and tried running "Excel.exe /regserver>ok" This did not help. I also ran defran on the drive. "Randell" wrote > Does anyone know how to solve this error? This is the > second time I have had th...

Change cannot be saved due to sharing violation
Hello I've this message while saving the excel file even if no change ha been done to the file. There is no share on this file (exclusive use) File resides on a network drive It's very disturbing Thanks for your help Vobiscu -- Vobiscu ----------------------------------------------------------------------- Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245 View this thread: http://www.msusenet.com/t-187102186 http://support.microsoft.com/default.aspx?scid=kb;en-us;328170 Thanks for your answer, I will try tomorrow noo Vobiscu -- Vobiscu ----------------...

SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has become chokers and have installed a new 1tb drive to keep up with demand for space. I need to move all the data to the new drive but unsure of the process. Is there an easy way of doing this? As it needs to be done asap Thanks -- JimmyJames ------------------------------------------------------------------------ JimmyJames's Profile: http://forums.techarena.in/members/255792.htm View this thread: http://forums.techarena.in/small-business-server/1357051.htm http://forums.techarena.in You c...

Importing AOL Email File Cabinet
Is it possible to tranfer a complete AOL Email File Cabinet into outlook? AFAIK, no, but see if anything here will do it: http://www.slipstick.com/config/convmsg.htm - check out Address Magic Plus first, it can convert almost anything. -- Diane Poremsky [MVP - Outlook] Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchange: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM Outlook Tips: http:/...

Changing query execution sequence
Hi all, I got a spreadsheet which would execute a bunch of queries. It's noted that the queries are executing in the sequence of when it was added to the spreadsheet. Does anyone out there know of a way to switch the order without deleting and recreating them? Thanks! Wing ...

140 MB file went to 5.08 MB after editting 1 table
Hello All - I need some ACCESS insight...please... Several years ago, I built an access db to track my business scheduling and accounts payable/receivable. So this database is EXTREMELY IMPORTANT TO ME. The file has grown to 140 MB. Today I made a copy of the file and then edited my calendar table. I removed all columns which had 2006 data (72 totals columns) - the table had about 144 columns originally. I then added 72 columns with 2008 headers. These columns are now blank since I have not added any 2008 data yet. Afterwards, I looked around and everything looks good - my 2007 data is the...

a few basic question about resource files
Hi, I have an application that uses resource files to contain the string values for each language. I have created the required resource files in my project, but I don't speak the languages I wish to have resources for. What I would like to do, is somehow allow the end user to edit the resource file themselves so they can set the string values as needed. Is there a way to edit the resource files that ship with my application and get installed ? or Is there a way to have external resource files (not embedded into my application) that can be updated/replaced with o...

Exporting contacts in a csv file
I am a mysterious problem exporting my contacts as csv file. The resulting file has only 58 contacts out of almost 1200 contacts in my outlook. These contacts appear to be the last 58 contacts added. (I say appear because the attribute "createdon" is not exported so I can't be exact. Why is this? cinnamngrl <cinnamngrl@gmail.com> wrote: > I am a mysterious problem exporting my contacts as csv file. The > resulting file has only 58 contacts out of almost 1200 contacts in my > outlook. These contacts appear to be the last 58 contacts added. (I > say appea...

is there a way to program my Excel file to do a loop?
Hi all, If I want B10 to B17 all follow the change of the same number(copy cell), let's say I put it in A1, and C10 follows the change of A2(copy cell), and C11 follows the change of A3(copy cell), and C12 follows the change of A4(copy cell), then I have 4 variables in my calculations: A1, A2, A3, A4. I want to loop each of the variables in a different set, then I hope the whole worksheet will be able to refresh following the change of A1, A2, A3, A4, and then I want to find the very set of A1, A2, A3, A4 that gives the smallest value of D10, how do I program the whole procedure...

Publisher can not save file
I recently started having troubles with my Publisher 2003. Whenever I go to save my files now, using save as or just the save button, it gives me a dialog box that says "Can not save file." It does that twice, then it disappears. I also noticed that when it does this, it leaves the .tmp files in the directory where I tried to save. I can change the name of the files, and sometimes it will save it. Most of the time not though. I have NAV, and I noticed that it was said there was an issue with Publisher and NAV. Is this the same with the 2005 version, and is this anything anyone...

Excel 2007 PC damages Mac Excel 2008 Files
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel When I open a Mac Excel 2008 file on Excel 2007 and I can work with the file, however when the file is returned to the Mac, it no longer works correctly, leading to a crash as soon as I try to save or eventually it might change the file to look like a bunch of letters and characters. Here is the error report: <br><br>Microsoft Error Reporting log version: 2.0 <br><br>Error Signature: <br> Exception: EXC_BAD_ACCESS <br> Date/Time: 2010-01-15 17:05:56 -0600 <br> Application N...