Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi - I am totally useless at writing macros:
we have a db that uses hrs and not man months as data- what i have to do is extract a spread sheet from the db which shows different values in hours eg (shown as 160h) in any columns or rows. what i would like is to apply a macro that removes the sign h and then divide the number by 130 which gives me my result in man months - i.e 160 h = 1.2 for every single value of the spread sheet extraction if any one can advise me ( or create one - if it easy !!) then that would be fantastic thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |