I have created a workbook that contains vlookup formulas. I also have another sheet (sheet2) that contains my data for the vlookup to work. The problem I have is that the sheet2 is quite big, it ranges from A1 to AL1 and will, once complete contain data covering A1:AL200.
I have 6 columns that contain the following heading menu 1 to menu 6 and each have ten rows (options). I have sheet2 set up as follows -
e.g. menu1 (B1) option1 (C1) option2 (D1) and so on till I reach ten (K1)
every time I go to enter data for a new row I have to tab along to nine spaces to enter data and so on. Is there any way I could enter data more quickly. Cell A1 contains a list of names and the cell has been data validated, this cell is also my 'lookup Value' and that name will always remain on that row its just then menu items I will be updating.
Thanks.