Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Info from one cell making other cells active

This is out of my league with Excel...I have a worksheet that I need
customers to fill out. Depending on the info they choose in one cell, will
make others cells become active and allow them to either choose the info from
a drop down field, or input their info into the cell--whatever I have chosen
for that cell. Is this possible, and if so...how do I do it...what is this
function called?
--
Bambi
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Info from one cell making other cells active

That's a lot of stuff! Everything you mention is doable, but requires a
little creative thinking and probably some intermediate-advanced knowledge of
Excel. You could pay someone to do the work for you, or get some good books
and do it yourself...but it may take a while...but the learning experience
would be great!!!

Anyway, here are some very good samples to get you started. Download
several files try to reverse engineer these elements for your specific needs.

Take a look at this too:
http://www.contextures.com/xlDataVal02.html


Regards,
Ryan---


--
RyGuy


"Bambi Williams" wrote:

This is out of my league with Excel...I have a worksheet that I need
customers to fill out. Depending on the info they choose in one cell, will
make others cells become active and allow them to either choose the info from
a drop down field, or input their info into the cell--whatever I have chosen
for that cell. Is this possible, and if so...how do I do it...what is this
function called?
--
Bambi

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
referring to formula in a non active cell from active cell nickname Excel Discussion (Misc queries) 1 June 21st 07 12:11 PM
I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER' CAPTGNVR Excel Discussion (Misc queries) 4 February 5th 07 08:27 PM
Making info appear in another cell tasadin Excel Discussion (Misc queries) 5 August 3rd 06 08:24 AM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
Making Hyperlinks Active In Entire Column JXD New Users to Excel 2 January 18th 06 11:28 PM


All times are GMT +1. The time now is 08:42 PM.

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

About Us

"It's about Microsoft Excel"