LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Mass Update! (Excel 97)

Hi,

I have several identical workbooks setup for each user, i need to update
these workbooks without changing any of the data that they have input. While
i can into each workbook individually and update the worksheets within thm,
would there be a way to perform a mass update on each workbook/wooksheet just
altering particular information?

For example, i don't want to update A-J only L3:24-AB3:24.
With the update i need to insert several new columns and also several new
rows but only within columns L3:24-AB3:24 (or L3:26-AO3:26, as it would
become).

Can this be done? I have a blank master workbook that i use to plan changes,
could this be used as a template?

Thanks,
 
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
How do I mass update formulas? karin Harpering Excel Discussion (Misc queries) 5 November 22nd 06 01:41 PM
mass tagging with excel? p2chang Excel Discussion (Misc queries) 1 January 23rd 06 02:45 PM
i have lost the small + that allows mass copy of formulas in excel Brendan Excel Discussion (Misc queries) 1 January 17th 06 03:29 AM
2 files, mass update comments between files Katycatchesnut Excel Worksheet Functions 0 June 2nd 05 10:16 PM
I want to do mass mailing in outlook, from an excel file that has. Franco Excel Discussion (Misc queries) 2 January 25th 05 07:49 AM


All times are GMT +1. The time now is 08:00 PM.

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

About Us

"It's about Microsoft Excel"