Posts by Carim
-
-
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 ...
-
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
-
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 ...?
-
It's not possible for me to determine if a macro was placed in the workbook without further information...
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
Code
Display MoreSub 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