LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,339
Default auto fill simple data

Hi,
look at

http://www.contextures.com/xlDataVal02.html

or consider using VLOOKUP FUNCTION.

"kevatt" wrote:


ok:

(a1) = my Ref IE: (A)= manully inputed data (my ref)
(b1) = my product text
(c1) = my price

when i enter the (My Ref A) in cell (a1) information needs to auto fill
both (b1) product text And (C1) price . i do not need to enter
infomation into b1 or c1 i think that the first cell (A1) is the cell
thats need the code

so in short i need to insert (manually) either a, b, c in Cell (a1)and
the informatin that is linked to either a, b, c will auto fill (b1) and
(c1)

if it helps the a,b,c is selected from a drop down list box


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=512352




 
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
Simple MS Query with Data Parameters Not Auto-refreshing [email protected] Excel Discussion (Misc queries) 0 March 14th 07 03:00 PM
Auto data fill in Slashman Excel Worksheet Functions 3 October 5th 06 12:25 AM
How do I get excel to auto fill data? Angelfsh9 Excel Discussion (Misc queries) 3 August 10th 06 02:53 PM
Auto fill for data from another worksheet Frustrated Accountant Excel Discussion (Misc queries) 3 April 1st 06 09:24 PM
auto fill sequancial data Art Excel Discussion (Misc queries) 1 February 2nd 05 01:21 PM


All times are GMT +1. The time now is 07:46 AM.

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"