Data appearing in wrong cell

[BarbaraDiane]

I was sent a spreadsheet that has a particular row where data is typed in one cell and appears in another. For example, if I type the word "No" in cell B11, it appears in cell O11. I have no merged cells in the spreadsheet.

 

[Smitty]

Welcome to the Board!

Does the value also appear in B11? If so, it sounds like you have a formula =B11 in O11.

Otherwise there might be a change event that's cutting the value to O11. To check you can right-click on the worksheet tab and select View Code. If there's anything displayed in the new window that opens you can paste it back here.

HTH,

 

[BarbaraDiane]

Thanks, Smitty. Neither is the case, to further comment, if I type in cell F16, the data appears in cell AE16 and so and and so forth across the row. Nothing showed up in the code. I would attach the spreadsheet, but I wasn't sure about doing that.

 

[Smitty]

In the VB Editor you might also want to see if there's any global event code in the ThisWorkbook module. You'll see it in the Project Explorer on the left-hand side of the screen.