I created a list in a worksheet that I have spent hours putting together. It
has been working perfectly for weeks, until now! For some reason the INSERT
ROW at the bottom of the list doesn't appear any more. I have tried several
ways to get around this, including unsorting all of my data in the list so
that every line appears, then converting the list to range then back to list.
This doesn't help. The nearest I came to fixing it was to copy the list and
its contents to a new worksheet and messing about with it there for a bit.
This kind of got it working (on the new worksheet) but there is a lot of
conditional formatting in some of the rows which won't copy into the new rows
as it did before. The data that is entered into this list populates about 5
more sheets with vital data for the buiness so this is a big problem. At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon