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.
|