dependent cells

Hi guys! Long time reader, first time poster. Getting very frustrated with my VBA so any help is appreciated. In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H. My VBA code...

Students names ( on normal cells) changed automatically when i select a class from dropdown list : How can i do this via formulas or via vba? for example: "dropdown list " : [Class 6-1 Class 6-2 - Class 6-3 ] Student name 1...

The MS page says that formulae in an embedded chart is not used for tracing dependents. But I find that, even with a non-embedded chart, plotted variables are not traced. Is this to be expected? It seems that a chart is not a formula! Is there a work-around??

Hello, I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate. On "Sheet 1", I have a listing of all the...

I edited a named range. The range clearly includes the additional cell. I can see it in the FORMULAS -> NAME MANAGER. But when I go to the drop down cell using that named range it does not include that additional cell as a choice. The drop down menu starts with the SECOND cell in the list...

How do I make cells that are dependent on a given result in excel, so that if I for example write 1234 in cell A1 other cells are dependent on this cells value and changes to given result from a third cell? Like this: When i put in the data in cell A1 then the data in cell A2, A3 & A4 is put...