Hi everybody,
I've got an excel file that basicly is a planning, it also generates a list of every activity so i could check if its ready to start.
Here comes the problem. it takes data from planning Row after Row, if it would do Column after Column the dates would be good allready.
# before starting to do everything as below Delete.TableName ("CheckListTest") 'this because after i updated values i want to create the same tablename back.
The list is not really easy to read because it took data from the planning row after row, if it did the same but then column after column it would be fixed.
The current macro copy paste the range ("F:Q"), this is where i put Y/N in case something is Y:ready or N:not ready. if i got N,N,N,N,N,N in range ("F3:Q3") it will copy this until the last column.
would be awesome if it only created Conditional format over tablerange, if none of cells in range ("F:O") contains "n" make ("P") of that certain row color green.
# make a Table named ("CheckListTest") with range("A2:Q, till last row Counted from E") inclusive headers in row 2 (for sorting the activitys on date)
Anyone who could help me with this?, all i need done is:
- deleting the table, Keep the headers for new table.
- Let the allready written piece of macro update values
- create new table with same name as before
- conditional formatting on ("F:P")
Here my file definitieve planning template 05-04-2017.xlsm
If you want to upload it back just delete Row 6 and down on the sheet "Startklaarlijst" this will bring filesize down :d
I dont even know if this is possible, but sometimes it happens to be the planning changes.
In the list "Startklaarlijst" as in my file, there could be alot of tasks marked with y/n allready in range F3:O
Is there any work around to save those y/n linked to the task ?
Bookmarks