I have a workbook that keeps on adding data thats not part of an autosum.
If you look on the enclosed workbook in cell Z7 im trying to do a autosum for cells M7 to Y7 but its also taking the data from E7 too and I dont want it to. Also in row 8 if you look in cell AP8 its doing the same.
Also in column "I", I need figures automatically changed to negative when data input. I have a macro on it but it done appear to be working.
Many Thanks
If you look on the enclosed workbook in cell Z7 im trying to do a autosum for cells M7 to Y7 but its also taking the data from E7 too and I dont want it to. Also in row 8 if you look in cell AP8 its doing the same.
Also in column "I", I need figures automatically changed to negative when data input. I have a macro on it but it done appear to be working.
Many Thanks
![1drv.ms](/board/proxy.php?image=https%3A%2F%2Fp.sfx.ms%2Ficons%2Fv2%2FLarge%2FXls.png&hash=dd9b436f3ad42a655ec71de4792f5224&return_error=1)