Search:

Type: Posts; User: Steffen92

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    1,388

    Re: SUM data from multiple sheets VBA code

    Hi Westconn1,

    Thanks so much. I found 1 small error, but now it is a elegant code.

    code:
    For rw = 5 To 23
    Worksheets("Overzicht").Range("F" & rw) = 0
    Next
    For Each ws In...
  2. Replies
    5
    Views
    1,388

    Re: SUM data from multiple sheets VBA code

    Hi,

    I found the solution and felt like sharing this with you. Probably not the most 'sexy and refined' code, but it does the job. Maybe someone has a tip on how to shorten this code:




    Sub...
  3. Replies
    5
    Views
    1,388

    SUM data from multiple sheets VBA code

    Hi Guys,

    I really hope someone can help me out on this relative simple VBA code (simple for more experienced users, which I am not).

    I want to consoildate the data from specific cells (always...
  4. Re: Simple VB code for date comparison and formatting

    Trying once more:

    180145
  5. Re: Simple VB code for date comparison and formatting

    Hi all,

    felt like sharing the solution. The formula which i have used in the conditional formatting is: =AND(IF(($Z7>$Z6);TRUE;FALSE);IF(ISEVEN(ROW());TRUE;FALSE);IF(ISBLANK($Z6);FALSE;TRUE))
    ...
  6. Re: Simple VB code for date comparison and formatting

    Hi Westconn1,

    would you be able to show me how it's done by sharing some printscreens? Thanks!
  7. Re: Simple VB code for date comparison and formatting

    Hi Westconn1,

    I want to format the cells in advance so that the formatting rules apply even after adding a new row. To get a better understanding on my challenge: this file will be used by...
  8. Re: Simple VB code for date comparison and formatting

    Hi Westconn1,

    Thanks for your reply. I am not quite sure that this will allow me to work with intermitted data (even and un-eve rows).

    The following functions came to my attention. Do you know...
  9. Re: Simple VB code for date comparison and formatting

    Hi westconn1,

    did you attach something in your previous post? I am seeing 'Attachement 180082' but was not able to open the file...
  10. Re: Simple VB code for date comparison and formatting

    Hi westconn1,

    as this file will be used by multiple colleagues, i am afraid that the formatting will get lost by colleages copy and pasting new rows's. Besides i do not quite know how to format a...
  11. Re: Simple VB code for date comparison and formatting

    Hi jmcilhinney,

    as is said, i am relative (very) new to VB and also this forum. I will be running this in the Excel add-in. Is there more information you need to know in order for you, or others,...
  12. Simple VB code for date comparison and formatting

    Hi all,

    I would like to do some VB coding where a relative simple date comparison leads to a formatting result. In the screenshot below there are 6 project represented on the A column. In the...
Results 1 to 12 of 12



Click Here to Expand Forum to Full Width