Was creating a workbook today comprising of 2 sheets. first sheet contains vlookups and the other 'sheet2' my data. Unfortunately I have to much data for the form option to work. Is there another option I can use rather than tab to each cell. Using excel 2003.
Basically when I created my database I was entering additional columns so that my vlookup formula could populate rows, e.g. I have 6 sections(columns) each containing 10 rows which are populated with a vlookup formula in each, works out at 60 columns of data. After inserting column number 30 I think, excel stated it couldn't perform 'form option' - too much data. The form option was very good because I just clicked a cell and it gave me the option of entering data quickly rather than navigating through a large data sheet.
This thread is now locked and can not be replied to.