I'm an experienced programmer (C++, C#, JAVA, ASP), but I know almost
nothing about Excel. One of our people gets a weekly spreadsheet containing
a column named "Actual Hours / BY". This column contains data like TI 21 /
DS 4 / RR 6. The data is simple text, and the number of items and field
length varies. Before you ask, I know this is a stupid way to send data, and
I have no idea why they do it this way.
Our guy wants a total of this hour info (e.g. TI 21 / DS 4 / RR 6 =
21+4+6=31). I suspect I'll need to define a new column in the VB editor and
write a snippet to total by row, then run a total on the newly created
column.
Problem #1: I haven't the slightest idea how to do this.
Problem #2: Our guy gets a new copy of this spreadsheet weekly, so I need to
run whatever function I create every week. Does Excel have a global cache
for stored procedures?