While working I created a spreadsheet that saves me alot of time daily but I'm stuck on a formula I need for the data in one workbook. I have a list of names in Cell A. That same list is broken down into different groups in other cells (Cells C, E, G, M). I am wanting a formula that I can enter into the other cells so that when i delete a name in column A it will delete the same name in the other cell it's in and then leave the other cell blank. I tried put the formula =a2, =a3. etc... in column c but when i deleted the info in column a it put a 0 in cell c...
Thanks for any and all help.
Thanks for any and all help.