Form option in Excel (data entry)

  oo7juk 11:06 01 Nov 07
Locked

Hi,

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…