I have a couple of worksheets and when I input information in one worksheet,
it feeds into another one and then adds to a graph. This is done on a daily
basis. The problem is however that I have run out of columns (max limit is
256). Upgrading to Excel 2007 is not an option for now. I need to either a)
start a new row of data but make it amend to the graph (which I can't seem to
get working) or b) convert the columns to rows so that I can have over 60,000
of them but when I use the paste special function, it doesn't do it right. It
leaves out the formula and I have tried many variations of this. Is there
anyone out there who can help me? Or who knows what the hell I'm talking
about!!!