-
compare values and paste in another woksheet
Hi all,
I have a worksheet that has a column "F" that has a drop down list between cells F24 to F63 with the following options
"crack"
"No Crack"
and a blank value
What i would like to do is sort each of these values and past into a cell in another work sheet
if all cells in the column = No Crack then paste "no Crack" in cell A1 of worksheet 2
if all cells in the column = Crack then paste "Crack" in cell A1 of worksheet 2
if a single cell in the column = Crack then paste "Crack" in cell A1 of worksheet 2
And if the pasted value ="Crack" then i want the cell to have red fill with white text.
Is this possible to do in VBA and if so how.
-
Did my reply at the cross post not help?
http://www.ozgrid.com/forum/showthread.php?t=158201
Please read this link about cross-posting and post a link to any future cross-posts
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules