| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to update based on format? (Currency)
For each sh in ThisWorkbook.Worksheets
For each entry in sh.UsedRange.Cells If entry.numerformat="currency" Then entry=entry*.2 Next Entry Next Sh I'm not sure if you use the word "currency" or something else, but this is the basic idea "Cindy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to update based on format? (Currency)
I thin k you will need something like
If entry.NumberFormat like "$*0.00" Then entry.Value = entry.Value * 1.02 -- HTH RP (remove nothere from the email address if mailing direct) "Jared" wrote in message ... For each sh in ThisWorkbook.Worksheets For each entry in sh.UsedRange.Cells If entry.numerformat="currency" Then entry=entry*.2 Next Entry Next Sh I'm not sure if you use the word "currency" or something else, but this is the basic idea "Cindy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Macro to import & update rows in spreadsheet based on Ref ID. | Excel Discussion (Misc queries) | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
| If statement based on currency format | Excel Worksheet Functions | |||
| Conversion from currency value to currency text format | Excel Programming | |||
Linear Mode
