Hi all !!
I'm still study VBA, and yes i learn a lot, but this sheet came to me and certainly i know how to do some stuff
and on mid of this there is a "missing link" (mentally speaking) that i don't know how to associated with Conditional formatting.
I'll ask you 2 question in one.
Question 1 : I'm asking for help to code for only 1 zone
Question 2 :what line of code do have to modify in order to include 3 zones, perhaps 9 zones ?
I'm doing this 2 question because of my learning, and i would like to know why and how lil things change when using VBA.
and also i want to apply by my self to 8 sheet with at least 50 zones in total.
Please i need help on this :
====================
-.Any Highlighted Numbers (i'm using 5) from Column A3 :38
that have "Y" on Column C3:C38 of Sheet "R-2" must
-.Transpose "A2" content Starting on Single cell "I5" of Sheet "T2"
-.Transpose Sorted Highlighted Numbers "A3:A38" Starting on Single Cell
"J5" Sheet "T-2"
-.The Formats of Transpose numbers to Single Cell can be with "," or "-" and Sorted
example:
3-5-13-24-28 (Please see Sheet "T1 ")
3,5,13,24,28
Next step
=======
-.If The "Y" from Column C3:C38 (Sheet R-2) are removed and Place new sets of "Y" to select new sets of numbers,
Then
-.Transpose "A2" content to next Available Single cell "I6" of Sheet "T2"
-.Transpose Sorted Highlighted Numbers "A3:A38" to next Single Cell
"J6" Sheet "T-2"
"R2 " Sheet Specs
==============
-.This Sheet have 9 Zones, (27 columns)
-. Each Zone have 3 Columns, (example in Zone 1 (A3:38, are linked to C3:C38 trought conditional formatted.)
-.First Column zone 1, A3:A38 Have numbers from 01 to 36 where
Numbers get highlighted If in 3rd Column C3:C38 i type the Letter "Y"
(formula used in conditional formatt is : ISNUMBER(SEARCH("Y",C3))=TRUE
-.2ND Column "Score" (B3:B38) i use as a reference, is not Important
what this sheet do :
===============
-.If in zone 1, anywhere Column C 3:C38, i type the Letter "Y" , (no quote)
e.i in Rows C3, C5, C6, C9, C11,
Then Column A with Numbers 03, 05,13,24,28 Get Hilighted .
Thank you a lot in advance..
Best Regards
David
Bookmarks