Search results

Here is my problem in excel.. B2 C2 D2 E2 F2 00038 371 0010170001 0270 38396 =CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2) Result is comming ----- 38 371 10170001 270 38396 But I need this result---- 00038 371 0010170001 0270 38396...

Hi, I have attached a excel sheet with this mail. In this excel sheet i have to find out the all match items and the criteria of the match item should be like this: Match Criteria if Journal ID = Journal ID then cut and paste the match items in another sheets these are three below...

Can you help me in using Vlookup; The senerio is like this : Sheet 1 Date Loan # Amount XXX YYYYY AAA .....n number of data Sheet 2 Date Loan # Amount descp XXX YYYY AAA ABC .... m number of data I...

Hi All, My moto is to whenever i change from A1 to A20 cell value. If my cell value is more than 25000.it should display the msg box saying " Please enter the value less than 25000. Note:- I have tried conditional formatting but it failes when i am copying any value from other sheet to my...

Hi, I need help in Excel. you can see the attached file. I have santosh_com.xls file with code which I am using on a daily basis but in this file I have some limitation like I cant take negative values in my permutaion-combination and also i have limitation where I cannot take more...

Hi All, I want to Import Excel file data in Access Table on Submit Button click through code. I would appreciate if you could help me in this reqard. Please find the enclosed files for the reference. In this file export button is working fine. But I am confused in " How to write a code in...

Hi All, I am trying to use the following code in "blue". Its working fine. But my problem is I want to use the below mentioned query in "red" in the following code but it is showing error msg " Expected end of statement " ********************************************** SELECT DATA.Account...

Hi All, I am trying to use the following code in "blue". Its working fine. But my problem is I want to use the below mentioned query in "red" in the following code but it is showing error msg " Expected end of statement " ********************************************** SELECT DATA.Account...

Hi All, I am trying to use the following code in "blue". Its working fine. But my problem is I want to use the below mentioned query in "red" in the following code but it is showing error msg " Expected end of statement " ********************************************** SELECT DATA.Account...