View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phendrena Phendrena is offline
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,