ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data Entry Using Pulldown (https://www.excelbanter.com/excel-worksheet-functions/79931-data-entry-using-pulldown.html)

Ben010

Data Entry Using Pulldown
 
I want to simplify entry of data into a large array. Here is the problem: I
have an array of data, each cell of which is associated with a corresponding
NAME (row of names at the top--a3:a60) and TASK (column of tasks--a2:z2). My
current method of entering data into this array is to scroll over to the
particular NAME and down to a particular TASK then enter a number into the
intersecting cell. It involves a lot of scrolling. I would like to create a
pulldown of the NAME's, thus dealing with only one column of data along side
of the TASK column. BUT, I want to be able to expand to the array when
necessary or when printing the whole spreadsheet. I know there is a
solution. Can anyone help?

Ben



All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com