thanks Prasenjit
this is really what i want If someone help to combine the features of the two workbooks, the problem will be solve.Please Help ..... thanks alot
Hi Narayan,
Yes i saw your uploaded file but inseted of write In H3 , i want write into the same cell which is E3 , if you go back to 2nd uploaded file which is " DataValCombobox mY.xls" you will see that Comobox & data validation have been combined together ... try to (Double)click any cell...
hhhhh.. sorry for that relay i don't know that upper case is for make hard but i have some problem with my computer ... sometime is hanging due to my damaged button ... but regarding the code i have no idea about it and relay you or any will help me a lot if this issue solved.....sorry again
thanks ... but i don't have a good English in writing ... might you don't understand me ... anyhow ... sorry for bothering you.... i don't know how i shouted
THANKS MAN ,
I TRIED WITH THE FORMULA BUT I THINK I HAVE SOME PROBLEM WITH CODE.
AS I NEED COMBO BOX FOR MALT I CELLS NOT ONLY ONE .... PLEAS SEE THE ATTACHED
I NEED COMBO BOX READ THE FORMULA AND BRING ONLY MATCHING VALUE THAT ENTERED.
THANKS
hi everybody,
really amazing site and good place of sharing information.... really thanks for all.
i have question , as you see in attached excel .. i have a lot of name and i don't know if there is any way let me search in the drop down-list for any part of name instead of put them in...
thanks .... i know how i can do Validation ....see below . attached again ... thanks for help
in F23 i put vlookup "=IF($M$9="","",VLOOKUP($M$9,Req,5,FALSE))" to give me the Job title of Requisition (M9) from Sheet(Reqs For offer)which is E2 but some time i need to change the position (job...
Hi Ravi ,
thanks for trying to help me....also thanks for every one who will try to give me from his exp... i updated the Sheet and i tired to explain what output i want in Green background .
thanks
thanks a lot but might i forget to put the formula originally the Merged cell contain vlookup "=IF($M$9="","",VLOOKUP($M$9,Req,5,FALSE))" to give the Job title (position) but some time i need to change the position (job title) from the form either by drop down or write the new position and not...
Dear Deb ,
as you know my worksheet,i have two more Q.
in ETA which is B8 in CRPO Sheet ... i want take the Max of Initial ETA & Revised ETA that located on column 18-19 on owssvr (1) Sheet.. but unfortunately it doesn't work if there is empty cell for one of them ..
2nd in...
yes if im not fixed the width of column 1 in sheet "owssvr (1)" ii gives me #N/A
i thinks becuse our date (Sharepoint) but if there is any way to avoid this error from excel sheet not from DATA base. instoed of doing fixed the width every and then after refreshing the data ...
THANKS DEB,
but unfortunately it doesn't work,,, i changed as you said like this
=IF($G$4="","",VLOOKUP($G$4,Table_owssvr__1,3,FALSE))
but still i need to to fixed width for the 1st column...really appreciated your help
REALLY THANKS ALL....
hI dEBRAJ ROY .. thanks alot my frind .....its work fine ... really thx.. but i have another prb.. you know this is linked to data base (Sharepoint) then when i export it to excel to let me work with this form ... once i type requstion NO. in G4 in CRPO sheet after...