Posts by Carim

Hi,

In your cell A9, you can have following formula

=IF(COUNTIF(Escala!$AI$7:$BZ$37,A3)=0,"Outro Número ",COUNTIF(Escala!$AI$7:$BZ$37,A3)/4)

Hi and Welcome to the Forum

A generic workbook which would perform the actions you have described would probably not help you out ...

You are not describing the situation your are facing ... nor the obstacle you need to overcome ...

If you are looking for a simple patch, you can turn on your macro recorder and go through your process once ...

You will get a "VBA-translation" of your actions, which can be a starting point ...

Hi Claire,

Well Done !!!

Congratulations on your new formula

Now that "the starting point" has been reached ... with all the basics (and cosmetics) being taken care of ...

Can you explain precisely the issue of dependencies ...?

Is it related to Column A - Priority - which allows, with Sorting, to stick to your logical sequence of production ... ?

Hi again,

Take the time to review attached test file ...

Before talking about macros and the structural display of your Gantt ...

You do need to clarify your Data ... and you inputs ...

1. How do I add date/day? Because planning will be weekly ....

If you add the start time and the duration ... the end time will be calculated ...

3. What if I need to change prioritize of the items in planning?

If you insert a Column A with an ID number ... you will always be in a position to sort your data ... by your priority ...

You can modify the Test file ... make your own adjustments .. and post it back if needed ...

OK ...

Let me quickly redesign the whole workbook to try to reach .... the starting point ...

Hello,

Before tackling specifically your questions ... there are several warnings and things to modify...

1. Whenever you are using Excel, NEVER EVER use MERGED CELLS ...

2. You seem to have hours and minutes in your data ... and days in Gantt .. tough to reconcile

3. How do you currently get your Gantt built ...??

Hello,

Quite honestly, attaching a tiny sample file ... to illustrate your latest question ... would allow all the potential ( and multiple ...) confusions to disappear ...

AliGW

Thanks a lot for pointing out the CROSS POST ....

It does Avoid Working to design a solution ... for NOTHING ...!!!

As the scheduler is done with all these designations, he can click a button which runs a macro to build the database

DrRandyman

In order to monitor your schedule regarding all the First Sundays of consecutive months, this would require to store all names selected in previous weeks ...

Do you agree to have a database built as you go along ...?

Quote from jennyfoster

It's not possible for me to determine if a macro was placed in the workbook without further information...

jennyfoster

For you info, the event macro is located in the Sheet module ...

Let me review the three new modifications you just added whenever I have a moment ...

Will get back to you as soon as I can

Thanks to Rory ... and thanks for your feedback

Hello,

Based on the Test file Version 2 posted in message #20...

1. Is everything working fine as expected ...

or

2. If it is not the case, ... thanks for listing exactly what is still to be modified ...

Thanks for your Thanks AND for the Like

Rica ederim

Hello,

Do you consider your initial question as fixed and your thread as Resolved ...???

Thanks for your feedback

Hello,

Below is your macro and test file

Sub Kopya()
Dim last As Long
    If Sayfa1.Range("DA9").Value = "Yes" Then
        MsgBox " Bu islem yapilamaz ... "
        'çikis
        Exit Sub
    Else
        'Kopya
        last = Sayfa2.Cells(Rows.Count, "BY").End(xlUp).Row + 1
        Sayfa2.Unprotect "1234"
        Sayfa2.Range("BY" & last & ":CS" & last).Value = Sayfa1.Range("DD9:DX9").Value
        Sayfa2.Protect "1234"
    End If
End Sub

Hope this will help