Form option in Excel (data entry)

  oo7juk 11:06 01 Nov 07


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.

Many thanks.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac