Home |
Search |
Today's Posts |
#1
|
|||
|
|||
macro
I need to create a macro with following funtion:
there is a table with two colomns. in the left one I have filled in all days of the year. the right column is filled in with data (numbers). SOme of the numbers are in red colour. The macro have to look for all numbers in red in the right column and to retur their sum in the first cell of the column which is empty. The mactro have to look from the begining of the column to the cell containg the date for today. |
#2
|
|||
|
|||
macro
Have a look at http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH RP (remove nothere from the email address if mailing direct) "Radoslav Radev" wrote in message ... I need to create a macro with following funtion: there is a table with two colomns. in the left one I have filled in all days of the year. the right column is filled in with data (numbers). SOme of the numbers are in red colour. The macro have to look for all numbers in red in the right column and to retur their sum in the first cell of the column which is empty. The mactro have to look from the begining of the column to the cell containg the date for today. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |