intersect

I'm using Excel 2010. I have two rows, H and I, that both have data validation enabled using a list. What I want to do is when a value is entered in one of the cells in column H have it be the default value in column I (same row) which can still be overwritten. I have named the two rows H =...

Hi I am very new to excel macros I am working with a spreadsheet that looks like this -- removed inline image --- Is there a Macro / Formula that could do this? Thanks for your help. S

I need to select the intersecting cell of 2 values. A2:A10 = Staff names B2:B10 = Dates (in 1 cell merged from 3) Thus select the intersection of eg. James and 1/2/12 All cells formatted as text, except the dates which are dd mmm. I intend to create a form that will enter data in the...

I need to select the intersecting cell of 2 values. A2:A10 = Staff names B2:M2 = Dates (in 1 cell merged from 3) All cells formatted as text, except the dates which are short date. I intend to create a form that will enter data in the intersected cell as determined by 2 combos, 1 for staff...

I have a list of names in cells C6:C17. If a user changes anything in this range I want to record the user name and date. The below macro serves this purpose to an extent. This event driven macro is fired if the user goes into the cell and then makes NO changes. How can I get the macro to...

I am trying to modify the following code: Public Sub Worksheet_Change(ByVal Target As Range) Dim pctVal As Double If Intersect(Target, Range("I14:I44")) Is Nothing _ Or Target.Cells.Count > 1 Then Exit Sub If IsEmpty(Target) = True Then Exit Sub With Target If IsNumeric(.Value) Then Select...

Hi. I'm very new to VBE, and while I've almost got an automatic GoalSeek function worked out, there's one last problem that I can't seem to find a way around (or a thread that covers it). As it stands, I can manually enter a value in cell B4 of the sheet with my GoalSeek function, and Excel...

Hi, Cells C3:C32 have data validation for a dropdown list. I need to prevent the user from deleting any entries in this column. The "Ignore Blanks" checkbox doesn't appear to have any effect, so I am using the following code... Private Sub Worksheet_Change(ByVal Target As Range) If Not...

Afternoon All, I wanted to change the whole row to bold between a range if a cell had selected within in and unbold the previous cell. You will see from my code that it is working. However i was looking to see if anyone had a neater way of doing it? If cludged mine together to make a working...

I need to display a message if a cell is changed. I got this working, but it's also displaying the message when a procedure puts a note in another column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> For example:<o:p></o:p> <o:p> </o:p>...

Hi all, I need to set a name to a range (Col T in sheet1) so I can use it in an Intersect statement. I am sure it is an easy fix but I can't see it. Extracts from my (latest attempt) code: Dim FailureGroupCodes As Range FailureGroupCodes = Sheets("Sheet1").Range("T:T") I have...

I have an input sheet, where column A has a dropdown list. Column B has a dropdown list that is dependent on the value selected in column A, using the INDIRECT function. One of the problems is that if the user then changes the entry in column A, I need to clear the entry in column B so that the...

Hi guys, I really hope someone out there in VBA land is able to offer me some assistance with this...even if that is to say that I can't do what I want to !! I'm writing a some VBA code that tests to see if two non contiguous ranges overlap. I'm using the Intersect method to test for this...