A very clever expert assisted with the development of the attached spreadsheet.
I'm now putting it through its paces. Basically the spreadsheet receives data and pushes the old data a row below the current row.
The problem I'm having is that there is a serious delay of a second each time a new value is introduced. Everytime, the spreadsheet receives a new value it pauses and a spinning round circle appears - its as if its trying to do a calculation. However, there is no calculation involved. The spreadsheet simply recieves data.
I was wondering if there was something in the formula that may be contributing to the delay? If an expert could take a look at it with a fresh pair of eyes may be you'll see something the original Expert missed?
The only thing that I can think of that may contribute to the delay is the conditonal formatting, but not sure.