All about Microsofy Excel FUNCTION

danielawth@gmail.com

Guest

Posts: n/a

3rd Aug 2012

How to make it auto fill-in the value(column C2) to column between column F2 to column K2 whitch is matching column E2 with between F1 to K1 :-

C2 - 3000

E2 - JULY (WHITCH I KEY IN)

F1 - JULY
G1 - AUGUST
H1 - SEPTEMBER
I1 - OCTOBER
J1 - NOVEMBER
K1 - DECEMBER

If i key in JULY at column E2, so the value(C2) will auto fill-in to column F2 whitch is matching E2 & F1, by the same time, when i key in SEPTEMBER at column E2, the value of C2 will auto fill-in to column H2.
thanks for help
Daniel Law

« Setting x-axis crosses with VBA | How to size the bars in a bar chart?? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server hint as to how many rows my fun	DR	Microsoft Dot NET Framework	1	22nd Nov 2007 12:36 PM
Microsoft Speech Recognition repeating error "all all all all all all...."	kenrosen@gmail.com	Windows XP General	1	17th Dec 2005 03:22 AM
Microsoft Speech Recognition repeating error "all all all all all all...."	kenrosen@gmail.com	Windows XP Help	0	16th Dec 2005 07:39 PM
Re: When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel	Niek Otten	Microsoft Excel Programming	2	18th Sep 2003 03:55 AM
Re: aol 9.0 and Microsofy Internet Explorer	aysha akbar[MSFT]	Windows XP Internet Explorer	0	28th Aug 2003 07:54 PM