Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rate sheet re-calculation
Every morning, numerous rate sheets are downloaded for company activities,
all with varying formats. I was wondering if there is any way to record a macro that will replicate the worksheet with the values all having a certain value incorparated to them. For examaple: If a rate sheet read: 6.0% 99.500 6.5 100.000 7.0 100.567 etc. Is it possible to transfer that to a new sheet, only with an addition of 0.5 to the values so it reads: 6.0% 100.000 6.5 100.500 7.0 101.067 If anyone can help me or if I need to elaborate further, I would greatly appreciate it. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pay rate Calculation for different shifts | Excel Worksheet Functions | |||
compound rate of return calculation | Excel Worksheet Functions | |||
Rate Calculation | Excel Discussion (Misc queries) | |||
Using linest for flow rate calculation | Excel Worksheet Functions | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) |