Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple coloumns data
I am not sure if this is possible or not, probably is, but i'm still
beginner in the world of macros. Gotta love your bosses!! What I'm trying to do, is take a productivity report, and color cod the different values. I already have the macro written for this however, my problem lays within the coloumns themselves. In on coloumn I have two sets of data, that I want to run two macros on. (ie. Macro1 for B1:B8 & Macro2 for B10:B15). The data for Macro1 wil not always be B1:B8. It varies from day to day. The last data inpu though is always automatically color coded light yellow. And th second set of data always begins 2 cells below the last cell of th previous. So my question is, can I create a macro that will run Macro1 on cell B1:B(light yellow) and Macro2 on cells B(light yellow + 2 cells):B? If it's possible and someone can help me out I will be mos appreciative. THANKS!!! : -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart to display multiple variables in 2 different coloumns | Charts and Charting in Excel | |||
Sorting Coloumns that are Formula's | Excel Worksheet Functions | |||
How do COUNTIF from two different coloumns but not all rows? | Excel Worksheet Functions | |||
data entered in each coloumns of one sheet to be extracted with r. | Excel Discussion (Misc queries) | |||
FILTER applied to many coloumns | Excel Discussion (Misc queries) |