View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cindy Cindy is offline
external usenet poster
 
Posts: 1
Default Macro to update based on format? (Currency)

Hi,

Wondering if someone might be able to help? We have a catalog with 50+
sheets. All sheets have different column layouts for printing
purposes. We need to update the price by a certain % regularly. Is
there someway to create a macro that would identify a cell for
currency format and then multiply it by a percentage from a set
sheet/cell?

I'm new at this and this is just an idea I had not sure if it's
possible but any help would be appreciate it.

Thanks in advance.

Cindy