Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben010
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simplified Data Entry Spellbound Excel Discussion (Misc queries) 0 March 24th 06 12:18 PM
Data entry using pull down Ben010 Excel Discussion (Misc queries) 0 March 22nd 06 12:55 PM
data entry form Excel Aart Dijkzeul Excel Discussion (Misc queries) 1 September 25th 05 01:57 PM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 02:21 PM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 05:33 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"