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
|