LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart to display multiple variables in 2 different coloumns LLively Charts and Charting in Excel 2 July 3rd 09 01:32 AM
Sorting Coloumns that are Formula's heritage1450 Excel Worksheet Functions 1 June 25th 09 05:37 PM
How do COUNTIF from two different coloumns but not all rows? JP Excel Worksheet Functions 1 December 16th 08 01:47 AM
data entered in each coloumns of one sheet to be extracted with r. rrenga72 Excel Discussion (Misc queries) 0 March 6th 08 09:51 PM
FILTER applied to many coloumns [email protected] Excel Discussion (Misc queries) 0 September 12th 06 09:52 AM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"