PDA

View Full Version : Solved: To Auto Populate Value



winxmun
07-06-2010, 06:13 AM
Hi there,
Anyone can assist for this query? :help

Based on the table below, how to auto populate the value from Charges Coloumn.
Example:
a. User choose APC and D, Excel to auto populate $50.
b. User choose CFS, F and $900 (mandatory) then Excel to auto populate the $150.
NameTypeCMVChargesAPCDNA$50 APCF$100 & below$100 APCF$101 - $1000$200 APCF$1001 - $2000$300 APCF$2001 & above$400 CFSDNA$55 CFSF$100 & below$80 CFSF$101 - $1000$150 CFSF$1001 - $2000$250 CFSF$2001 & above$350

winxmun
07-06-2010, 06:22 AM
Realised that the table is jumbled up. Hence attach the excel file.
tks.

Tinbendr
07-06-2010, 09:44 AM
how to auto populate the value from Charges Coloumn.
To where?


Example:
a. User choose APC and D, Excel to auto populate $50.
How does the user choose?

winxmun
07-06-2010, 11:47 PM
To where?
Based on excel file example, Column A is name, Column B is Type, Column C is CMV, auto populate value of Charges at Column D.

How does the user choose?
I am thinking of creating droplist for Column A & B, Column C is free text (user to input amount), column D is populate field.

Example 1:
User chooses APC from Column A, then D from Column B (need not input amount at Column C); Excel to auto populate value (according to the matrix maintained in excel) at Column D.

Example 2:
User chooses CFS from Column A, then F from Column B, input amount at Column C; Excel to auto populate value (according to the matrix maintained in excel) at Column D.

winxmun
07-07-2010, 03:41 AM
I've re-create another excel file to clarify my query. Pls assist to refer to the file attached. btw, this file's macro/ VBA was from another person. i didnt take away. tks a lot....:yes

mdmackillop
07-07-2010, 09:22 AM
This looks up a grid containing the data and returns the result using the OFFSET function

winxmun
07-07-2010, 09:26 PM
Hi mdmackillop, sorry i think i am confused. :banghead: Thus, my question is very messy and unclear. Pls ignored my earlier question and refer to the latest excel file attached for the queries.
Hopefully i got my question right this time...: pray2: tks.

winxmun
07-09-2010, 07:36 AM
Hi anyone out there can help as i am very desparate for this. tks...tks...tks...

winxmun
07-12-2010, 12:41 AM
Hi everybody,

Anybody can helpppppp.....please......tkssssssssss

Aussiebear
07-13-2010, 03:00 PM
What part of Malcolm's solution doesn't work for you?

winxmun
08-02-2010, 07:20 PM
Hi All,

Managed to resolved the error and completed the template. Attached for all to review.

tks...:rofl: