Search:

Type: Posts; User: Vishaal; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    132

    Re: Search and Match and show the result

    Hi DanteAmor Ji,

    if we are using your code with the sample data its working fine but when we are using with the following sheet its not working, we have also check it with making some changes in...
  2. Replies
    7
    Views
    132

    Re: Search and Match and show the result

    Hi Sir,

    We are using the code and want some modification, like

    1. if we need to add or remove header data from two rows to one rows or six row, how can we do that
    2. how can we fix that the...
  3. VBA CODE EDITING - Search and Match and show the result

    Hi all,

    We are using the following VBA code



    Sub Search_and_Match()
    Dim sh1 As Worksheet, sh2 As Worksheet
    Dim lr As Long, lc As Long, col As Long, lr2 As Long
    Dim c As Range, f As...
  4. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thank you very much Rick Rothstein
    Sir Ji for the help

    its a proud that i m a member of a great forum
  5. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thank you very much Peter_SSs Sir Ji for the help

    its a proud that i m a member of a great forum
  6. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks Rick Rothstein Sir Ji, its working for me, thanks for your support.

    One query is still pending and that is if we need "Three or one" yes what modification required in your following code
    ...
  7. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks Rick Rothstein Sirji, checking the code
  8. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    same as previous, my problem is in column c, there is only two entry and if we use code, it will paste four yes, which is wrong

    advice pls advice on if we need "Three or one" yes what...
  9. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Peter_SSs Sir Ji,

    i forget one thing with my data, i have changed in column C, in that situation what modification required in your code (#21)because we are using "four Yes" and there is only two...
  10. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    thanks sir

    thanks fir the help
  11. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks Peter_SSs ji,

    I will check and update u
  12. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thank you Rick Rothstein Ji,

    Thanks for your code and giving time on my post.
  13. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thank you very much Peter_SSs ji

    Its working

    Thanks for your code and giving me time
  14. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Hi,

    After using the code we are getting the following result

    Excel 2010 32 bit

    A
    B
    C
    D
  15. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    One more problem with code when we are trying after changing c 2 to 200,all "Yes" are starts from last, i mean in every coloumn supoose we have 16 rows then all "Yes" are pasted from row 13 in every...
  16. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Hi, the above vba code are working fine for the above given data but when i am adding some coloumns and row, coloumn AtoCB and rows 1to25

    The above code is not working

    Help pls
  17. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks lrobbo314 JI,

    Its working for me,

    Thanks for your help
  18. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks Yongle JI,

    Its working for me,

    Thanks for your help
  19. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    Re: VBA Formula

    Thanks Peter_SSs JI,

    Its working for me,

    Thanks for your help
  20. Thread: VBA Formula

    by Vishaal
    Replies
    31
    Views
    667

    VBA Formula

    Hi All

    Thanks in advance,

    I have the following sheet

    Excel 2010 32 bit

    A
    B
  21. Replies
    7
    Views
    132

    Re: Search and Match and show the result

    Many thanks DanteAmor Ji

    Its working for me and saved my lots of time

    Thanks sir ji
  22. Replies
    7
    Views
    132

    Re: Search and Match and show the result

    Thanks for giving the time DanteAmor Ji

    1. Yes, the names in headings are in two row
    2. "5" is a number which have "Yes" in second data

    I m checking the following

    If H4 value from first...
  23. Replies
    7
    Views
    132

    Search and Match and show the result

    Hi All,

    Thanks in advance,

    We want to check and match from two sheet as per given sheets

    First Sheet from where we will compare and match

    Excel 2010 32 bit
  24. Replies
    6
    Views
    123

    Re: Split the Number

    Thanks Rick Rothstein JI

    its working for me Left Digit: =INT(E1/10)
  25. Replies
    6
    Views
    123

    Re: Split the Number

    Thanks Peter_SSs Ji


    Its working for me
    <tbody>
    F1
    =LEFT(TEXT(E1,"00"))

    </tbody>
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4