Thread: Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob[_20_] Rob[_20_] is offline
external usenet poster
 
Posts: 1
Default Macros

I have a quotation program with 4 saparate tabs along the
bottom. I've distributed this to over 200 customers, and
now I need to change prices on some items, about 24 on
each tab, total of nearly 100 prices to change. Can you
think of a systematic way to do this? Due to security,
only qualified customers get this program, so I don't want
to just post an updated .xls file on my web site. I was
hoping to distribute a macro or something that could
automatically find and change the selected prices. Can
anyone out there help me?? THANKS!!!!!