Hello Everyone,
I having some issues to do this planning project which am working on. I would be very grateful if I can get some guidance on how to do it either by formula or vba please.
I have attached a sample of the data for better understanding.
I am using actually this formula which takes data from several columns and concatenate for the visual view of the user rather than going through the big file to see the information.
The formula is as such :
=IF(CE$10=$BF11,$C11&"-REF: "&$G11&"-TDG: "&$AT11&"-LOADED LINE"&$AO11&" - ORDERED: "&$H11&" - FAB: "&TEXT($K11,"DD-MMM"))&"- CUT DATE: "&TEXT($AA11,"DD-MMM")&"-SEW: "&TEXT($BF11,"DD-MMM")&" TO "&TEXT($BG11,"DD-MMM")&" - DEL: "&TEXT($BP11,"DD-MMM")
It check is the date from the planner which is actually CE10 equals to the Start Date Sewing column which is actually BF11 and if the dates meets then it will starts concatenating the data as on the formula from several columns which shows a result as such below:
RESULTS: TIM-REF: DRESS-TDG: 22.59-LOADED LINE3597.79 - ORDERED: 3493 - FAB: 27-Feb- CUT DATE: 16-Mar-SEW: 04-Apr TO 24-Apr - DEL: 15-Apr
1. After that I will have to color the rows till it meets the End Date Sewing Column which here as example is 24/04. Can see the attached sheets for example.
2. Then I will have to merge the cells together till the end colors cells so that the column start from CE11 to CR11 shows only the data for this specific order.
For the other orders I will repeat the same whole process by copying and pasting on each start Sewing Date .
I have also another formula which am unable to place as its too many arguments:
=IF(K12<>"","T"&" "&I12<>"","A"&" "&R12<>"","O"&X12<>"","OF"&" "&AF12<>"","VA"&" "&AG11=<>"","L")
This one it shall check from example the Bulk fabric date Column ( K12) is not blank then assign the value “T” and if the achieved column which is L12 is blank then it shall turn the value “T” to red showing the fabric still not in . And keeps doing same for other parameter to check also same way.
Can someone please guide me on how I can proceed with it either by VBA or Even Formula please.
Actually we are doing this manually and its very very time consuming. We can complete this report like in 6 -8 hours only as there are many data like this to treat and every changes that happen we shall again update it manually again losing a lot of time.
Thanks in advance for any even a small guidance please.