Search results for query: *

Sir plz have a look i am blank about this problem

If c.Offset(, 15) > c.Offset(, 16) Then like this will be the next step

Sir i am not a professional guy like u what i know and what i understand i told u if i am not understanding what u mean to say then plz provide me the code so that i can learn from the same and from my mistakes

Sir we have already use the application.matchlookup of column E and Column A perfectly i am unable to do from that part

the ball is in your court means Sir u know from the starting that this problem is not like a nornal question thats y i started the post otherwise i am solving the smaller vba problems

Sir it will take some time to understand sir i have tried but i am blank about this problem so plz help i will learn something new about vba from this problem sir so plz help

Sir i tried in many ways after that i have posted the same i googled and i saw examples like this problem but i was unsuccessful to resolve the same

Sub Code() Dim wbk1 As Workbook Dim wsh1 As Worksheet Dim wbk2 As Workbook Dim wsh2 As Worksheet Dim r1 As Range, vRow2 As Variant, sLookup As String Application.ScreenUpdating = False Set wbk1 = Workbooks.Open(ThisWorkbook.Path & "\sample1.xls") Set...

If column E of sample1.xls matches with column A of sample2.xlsx then look column O of sample1.xls and column P of sample1.xls & if column O of sample1.xls is higher then calculate the 0.50% of column O of sample1.xls or if column P of sample1.xls is higher then calculate the 0.50% of that and...

Yes i got the solution i have to repost my question as sir said

sure sir

Sir one of my open post (topics) has been deleted plz check i have not deleted sir plz have a look i think some technical problem has happened

Thnx SkipVought Sir and Deniall Sir for giving ur precious time and great guidance to this post

i dont have any problem plz see the problem and check my code is it perfect i sented u only for a guidance that this is perfect bcoz i writed the code of some copying and some editing

I have file file name is macro1.xlsm i have a second file file name is 1.xls i will add the macro in macro.xlsm my first row contains headers in 1.xls file If column D of 1.xls file matches with column H of 1.xls file then delete that complete row and save the changes and close the file This is...

Thnx Alot Skip Sir for ur great guidance and thnx for the help Sir

Sub Code() Dim wbk1 As Workbook Dim wsh1 As Worksheet Dim wbk2 As Workbook Dim wsh2 As Worksheet Dim r1 As Range, vRow2 As Variant, sLookup As String Application.ScreenUpdating = False Set wbk1 = Workbooks.Open(ThisWorkbook.Path & "\1.xls") Set wsh1 =...

that if there is a data in column B then add or subtract it depends on the data

Sorry Sir i understood my mistake in future it will not be repeated

But i am unable to write a code for the same ?