Search results

Hello, Its not working as zeros are missing...

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

Hello, It is still giving me the " #NAME?" I would really appreciate if you could place this formula in my excel sheet & upload it again. Thanks a lot. Please help urgent.

Hi, I am still confused :confused:could you please help me to understand with the data.I would really appreciate your effort. Please find the attached. santosh

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

Hello, I have attached my excel sheet please review the error and in this sheet user can easily enter the value more than 25000. and its still giving the error when i am pasting any value from other sheet which is more than 25000.:confused::confused: thanks

Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = ActiveSheet.Range("a1:a20") If Not Intersect(Target, rng) Is Nothing And Target.Cells.Value > 25000 Then MsgBox "Please enter the value less than 25000!" End If End Sub above mention code is working fine but just...

Hi sorry for the confusion. i just want to know that how would I use this code in excel. please help. Thanks

Hi, Thanks for yor effort. I am still confused. Please help me how to put this code in excel as I am very new to VBA. Thanks a lot.

I am still confused I would really appreciate if you could give me any sample excel file with vba code or full code for the same. Thanks and regards

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 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, "THANKS A LOT" " YOU ARE GREAT "

Error is showing.... COMPILE ERROR: SUB OR FUNCTION NOT DEFINED please find the enclosed print shot for the error

Hi, I am trying to use the following code but its not working My access table name is = DATA File which I want to import name is = dps.xls Private Sub Command3_Click() Dim myfile As String, sql As String Dim db As Database, rs As Recordset, rs_target As Recordset Set db = DBEngine(0)(0)...

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

Thanks a lot....the above mentioned code is working absolutely fine. I need more help from you I have changed my query to SELECT DATA.Account, DATA.Affiliate, DATA.Deal, DATA.MFR, DATA.GL, DATA.YTD_Balance, DATA.Adjustment, DATA.Difference, DATA.Description, DATA.[Owned By] FROM DATA WHERE...

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