Resolved(Sorry Again Please Advise on this)

[VBcielle]

can you help me make a work around for this problem

i have two combo box in sheet 1
1. For Pal Line
2. For Transaction Level

all values in pal line and transaction values is generated in
Sheet 2 as my database

see attached screenshot of my sheets.

how can i fill the range of all PAL line Colums in my Pal Line combo bOx
as well as fill the range of the transaction within the Pal Line?

for Example PAl Line 1 has 2 transactions
and Pal Line 2 has 1 transaction

so if user's choose Pal Line 1 value in the PAL lIne combo box
only two transactions will appear in the Transaction Level combo box

help me..