Search results

Hi Friends, I want to create a userform in excel which contains name,mob no.,address,place. then if i click on the command button submit, the whole data should be copied to a sheet2 which contains a database. Pls guide

Hi friends, Pls help me over this.. if i enter value "1" in a1, i need toyota logo to be displayed in C1, if i enter 2, i want honda logo to be displayed in C1.... Pls guide

thank u luke M .......

thank u sir hui...

Hi everbody, Pls suggest a suitable formula for me for the below data. If in A1 the data is honda/mahindra/audi/benz(any 1 out of 4) in b1 the data should automatically come as "good cars". If the data in A1 is other than those 4, in B1 the data should be displayed as "will be examined"...

thanks sylar & jason for ur suggessions

Hi SirJB7 Your sheet is perfectly working. Thanks a lot I just want to trouble u a bit more. Now i have created 4 different sheets, sheet 2-audi, sheet 3 mahindra etc.... if in A1 the car is audi and in E1 if it is "S", i want the whole row to copy to audi sheet, likewise all car data to...

Hi all, I have data in sheet 1 as under A B C D E SANCTION(s)/REJECT(R) TOYOTA MAHINDRA HONDA AUDI S/R Now if the data in E1 is "S", then i want the data from A1:D1 to automatically copy in sheet 2. Pls guide

Hi naraya, Thanks a lot...my work done. Thank u very much Looking forward to ur support Harry

Hi Narayan/bob/Luke Could u pls help me in macro for my doubt???

Hi all, I have data as under A1=1 B1=2 C1=3 D1=4 E1=1+2+3+4=10. Now if i change A1=2, in E1 i want value to be 12(10+2), if i change B1=3, i wamt E1=15(10+2+3)... Pls guide

thank very much vijay..work done..

thank u very much.... you told a very easy method for my problem. actually i was using multiple if formula for that....vlookup is very easy..thanks a lot. Now one more question i have is, if the data doesn't match to the data used for vlookup #N/A should not be displayed, rather i want the...

Hi all, I have 45 branch names in column A, each br name has got a different br code. Now if i enter a branch name in A1, automatically corrsponding br code should be displayed in c1....likewise i have 45 branch names with diff br codes... Pls guide

Hi, I have a 4 values in A1. Personal loan, Home loan,car loan,business loan in A1(Data validated) Now if i select Personal loan, the rows 1-23 should hide themselves, if i select home loan, 1-23 should unhide and 23-46 rows should hide automatically. Pls guide

Thanks Faseeh, i have problem with concatenating the values. suppose i have a value 1000 in A1, i want it as 1,000 or 10000 i want it as 10,000..like wise (Indian format). and when i use your formula in concatenating, the commas are again getting disappeared... waiting for ur ans

Hi all, 1)i have a value in cell A1=1243848. Now i want it as 12,43,848(with commas) in B1. how to do it??? 2)When i concatenate B1 with another cell, the commas will disappear. Pls help

I have 5 values in A column and 5 values in column B. A column B 1 10% 2 20% 3 30% 4 40% 5 50% i hve data validated the values in A. Now if i select 1 in A, the 10% should get bold, if 2 then 20% should get bold..like wise... Pls help

@Kaushik if nothing is selected, b1 should be empty...how to do it?

Thanks a lot kaushik...

@bobhc: dint get u, where did i shout in the previous post...

Thank u sir hui & Jason

I have data validated 3 feilds in A1. if i select apple in a1, in b1 it shouls come good,if i select mango in b1 it should come "better", if i select banana in b1 it should come "best" like vise i have 5 conditions..... Now if i dont select anything the cell b1 should be blank... Pls...

Hi all, I have a prob in IF formula. I have a data in cell A1. I have data validated the values in cell B1. eg, i have a question in cell a1 as 1+2=? the values in drop down list in B1 are 2,3,4. now i have 2 problems. 1) the arrow mark of the data validated cell should always be seen...

Thank u sir hui & sir JB7