Recent content by HVK1986

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