Posts by Carim

You can test following modification

Sub Hide_Columns_Toggle()
Dim c As Range
 For Each c In Range("A5:Z5")
   If c.Value = "*" & "Completed" & "*" Then c.EntireColumn.Hidden = Not c.EntireColumn.Hidden
 Next c
End Sub

Since you apparently want to Toggle between Visible and Hidden Columns, would suggest testing the following macro

Do Not Forget : Not ....

Sub Hide_Columns_Toggle()
Dim c As Range
 For Each c In Range("A5:Z5")
   If c.Value = "Completed" Then c.EntireColumn.Hidden = Not c.EntireColumn.Hidden
 Next c
End Sub

Hope this will help

Hi,

Just out of curiosity ... does the macro you have posted generate your expected result ?

Hi again,

Can you see the difference between the way your text was displayed Originally (with Code Tags) ....

and the current display .... once the Code Tags have been removed ...

The Code Tags are represented by the little icon </> in the Top Menu ... only to be used for macros ...

Thanks a lot for your Thanks AND for the Like

Attached is your Test file Version 2

Hi again,

Unfortunately, you are not using Excel with a clean database method (flat file) ... but rather like a Word processor ...

As a consequence, it does create unnecessary complications and imposes some patches for your macro ...

Attached is your last Test file Version 3

Hope this will help

Hello,

Thanks for using the Code Tags ONLY whenever you are posting a macro ...

For standard text, there is no formatting required at all ...

Você é bem vindo

Thanks a lot for your Thanks AND for the Like

Hello And Welcome to the Forum

Attached is your test file

Hope this will help

Quote from clairexcel

LOOOL, I know ahaha it is my day off soooo

Well noted for what I have to work on.

thank you Carim, will give you now a break until...tomorrow

Too Kind of You !!! Have a Nice Evening

You are digging SOO FAST ...

I can't keep up with your crazy rhythm !!!

The main issue, for you, is to make sure the ideal sequence is displayed as much as possible in sheet Raw Data ... since it feeds into Data and directly into Gantt ...

Now if you do need to modify Priorities in sheet Data ... ( you have already noticed Sorting is performed as you go ...)

hopefully you can easily ( if not automatically ...) adjust both Start and End Dates ... in order to achieve an error-free Gantt

Hello again,

Attached is your test file

Hope this will help

Thanks a lot for your very kind words ... for your Thanks AND for the Like

Glad to hear the latest version can help you out ...

If you manage to better "decode" the Raw Data ... mainly Columns B and J ...

we could even end up with a fully automated process which would go beyond the automatic sorting based on the Priorities ...

Let me know if you feel like "digging further" ...

By the way ... if you ever need to Convert SAP Casino Decimal Time hh . mm into an Excel Actual Time hh : mm

in sheet Raw Data, in cell K2, you can use following formula :

 =(INT(J2)/24)+ROUNDUP(J2-INT(J2),2)/14.4

Quote

Quick question about Column J you say Hours-Minutes ... what about Rows 33 and 38 ... with 60.94 ???

- It is 60 hours, yes, although I suspect production manager has exagerated excution time for that particular item...

60 Hours OK ... but what about 94 MINUTES ... !!!!

For sure SAP is NOT CAPABLE to convert MINUTES into HOURS ... !!! Che Casino ...!!!

Hi again,

Attached is your Test File V2 ...

Quick question about Column J you say Hours-Minutes ... what about Rows 33 and 38 ... with 60.94 ???

Please note if your sheet "Raw Data" is sorted by Column B ... your previous sequences in Columns F & G are modified ...

In this file, sheet "Data", you can modify Priorities in Column A and in Column N ... Re-Sorting is automatically performed ...

BUT ...obviously, for Both Machines, your Start Dates and End Dates must be re-visited due ... to compliance to your dependency rules ...

AliGW

Honestly ... I have to sympathize with your simultaneous monitoring on all Excel Forums ...

Quickly checked ... no feedback ... in any of the THREE Forums ...!!!

Great ... !!!

So if my understanding is correct ... your "Raw Data" worksheet is a download from your main frame ... and ideally it should automatically feed and complete your worksheet "Data" ...

By the way ... SAP is by far the worst possible piece of software on planet Earth ...

Questions :

1. Would you need a formula to fill in your Machines in Column A ? test in cell A2 =MOD(ROW(),2)+1&"A" - To be copied down

2. Are you manually modifying the production dates in Column B ?

3. How to set the priorities by machine ? Can it be automated ?

4. What is Unit used by Column J ?

I was extremely optimistic when I said "we had reached the starting point ..."

A few remarks :

1. Your machines are totally independent one from the other ... OK

2. Your Sheet Raw Data is totally empty ... why ... ???

3. In the Data Sheet, Machines are separated ... OK ... But, in Column N ... Why don't you have your Priorities sorted ...?

4. Dependency is in fact a direct consequence of precisely your sequence of items ...i.e. your priorities

5. To get the Start of a given item just after the End of the previous one, you can set your Lag to Zero

Ideally, could you replace the data I have used for test/demo purposes by some real-life data to ensure we are heading in the right direction ...

Let me have a look at your latest version ...

Meanwhile ... I am extremely impressed by the speed at which you are progressing with Excel ...!!!