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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rate sheet re-calculation
One alternative play using grouped sheets and a formulated col which might
suffice Assuming the data is in cols A and B, from row2 down, and that all source sheets are identically structured Click on the leftmost sheet tab, then while holding down SHIFT, click on the rightmost tab. This will group all the sheets for the following actions .. Place into C2: =IF(B2="","",SUM(B2,0.5)) Copy C2 down as far as required to cover the max data extent expected for any single sheet within the grouped lot. Then right click on any of the grouped sheets Ungroup sheets. Col C in each sheet will return the required results. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TMc21" wrote: 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 incorporated to them. For example: 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. |
Reply |
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) |