Skip to main content

VBA

  • June 2, 2017
  • 1 reply
  • 0 views
D

Guys can you help me with this 1? i try so many method but still cant find any answer

im new in VBA  and here is the scenario

 

i have 4 sheets which is user1, user2, user3 and data. (the screenshot is in the data sheet)

I want to create a vba macro that will check the user ID and the worktype then send the value of " count(under H column) and Error point(under I column)

and also if you can see there is 2 similar worktype under user 1 "maid". if 2 similar worktype is on the data sheet under same userid i want to sum all the same worktype and copy it to user1 sheet

 

Thanks 

    1 reply

    Chris Glazier
    Forum|alt.badge.img+2

    Guys can you help me with this 1? i try so many method but still cant find any answer

    im new in VBA  and here is the scenario

     

    i have 4 sheets which is user1, user2, user3 and data. (the screenshot is in the data sheet)

    I want to create a vba macro that will check the user ID and the worktype then send the value of " count(under H column) and Error point(under I column)

    and also if you can see there is 2 similar worktype under user 1 "maid". if 2 similar worktype is on the data sheet under same userid i want to sum all the same worktype and copy it to user1 sheet

     

    Thanks 

    I am not sure that you have the correct forum here. This is the Micro Focus Visual COBOL forum. The question you are asking deals with Visual Basic for Applications which is a Microsoft language.

    Were you looking for a way to perform this task in COBOL?

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement