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

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"...

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 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

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

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

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...

In A1 i have names "car,house,bike,mountain,chair" i have data validated and inserted a dropdown for all these names. I have photos of car,house,mountain,bike chair on my desktop. Now if i select car in A1, in B1 photo of car should be displayed Now if i select house in A1, in B1 photo of...

Dear Sir Hui, pls suggest me a formula for the below mentioned data. if in cell A1 the amount is <25 then in B1 it should display "not eligible", if amount in cell A2 is >=25 and <50 in cell B1 it should come as 50, likewise >=50 but <100 it should come as 60, and >100...

HELLO ALL.. MYSELF HARISH KULKARNI AND I WORK IN A BANK. I WANTED HELP FOR THE IF FORMULA. I HAVE A DATA AS UNDER IN CELL A1 IF THE AMOUNT IS >0<=60000 IN CELL B1 IT SHOULD COME AS 20%, IF IN CELL A1 THE DATA IS >60000<=200000 IN CELL B2 IT SHOULD COME AS 25%, LIKE WISE...