Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default port formula changes to multiple workbooks?

I have multiple instances of the same basic workbook - each with
different data sets, but the same cell formulas and VBA code. If I
change some formulas, is there a simple way to port the changes to these
other workbooks, without disturbing their data? No cell locations are
changed, no cells added, ... just changing some equations.


(I believe I could go to each sheet, Select All, and then
'Paste_special.Formulas', etc. I'm hoping there's a less tedious
method.)

Thanks,
George
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine multiple workbooks into 1 workbook w/ multiple worksheets buffgirl71 Excel Discussion (Misc queries) 1 May 13th 06 12:28 PM
Interfacing USB port and MS Excel Arun K Excel Discussion (Misc queries) 0 November 7th 05 07:55 AM
How do I copy info from paper port to a cd? annes519 New Users to Excel 2 July 5th 05 03:04 AM
One formula on multiple workbooks question Josh M Excel Discussion (Misc queries) 1 May 24th 05 03:17 AM
I'm copying and pasting Cisco port informaton: 2/11, 2/4, 3/10 bigmo29 New Users to Excel 3 March 17th 05 12:51 AM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"