Saquib Ahmad Shuvo

No, it is not possible cause the VLOOKUP function in Excel cannot be used to enter multiple criteria as a lookup value, so you won’t be able to get your desired result.

Thank you so much for sharing this information with me.

Hi MICHELLE,
Greetings and thank you for your inquiry.

To apply the above formula to the extra payment, you need to change the formula in cell H12 as follows:
=H11+G12-D12
This means (Original Balance-Principal-Extra Payment).

Greetings, Huda.
I appreciate you asking this question. Solved examples are available about distribution or transportation problems. You can find it here “Solving Transportation or Distribution Problems using Excel Solver”.

Greetings ALAN,
I appreciate you asking this question. Excel will automatically generate this date in the intermediate stage when you are trying to create a gannt chart. During the Final stage, you will notice that project-1’s starting date has been corrected.

Dear Macel,
Greetings. In order to track project progress in Excel and incorporate additional tasks, milestones, and percentages, you can follow these steps:

Open your project tracker in Excel or create a new one.
Make sure your tracker has the necessary columns to accommodate the new tasks. You can add columns for line numbers, X-ray, hydrotesting, painting, NDT (non-destructive testing), dye penetration, and any other relevant tasks you mentioned.
To maintain the formatting and calculations in your existing tracker, insert new rows for the additional tasks. Right-click on the row number where you want to add the new tasks and select “Insert” from the context menu.
Enter the task names and other relevant details in the newly inserted rows.
Adjust any formulas or calculations in your tracker to include the new tasks. For example, if you have a column for task completion percentages, you may need to update the formulas to include the newly added tasks in the calculation.
To ensure that the total progress always adds up to 100%, you can either manually adjust the percentages or create formulas that automatically calculate the percentages based on the completed tasks.
To add milestones to your tracker, you can designate specific rows as milestone markers. You can either create a separate column for milestones or use conditional formatting to visually highlight the milestones. You can also add a separate column to describe each milestone and provide additional details if necessary.
Remember, the specific steps may vary based on your Excel version and the structure of your project tracker. Experiment with different approaches to find the one that suits your needs best.

Dear Macel,
In the comment above, I already answered your question.

Dear Macel,
Greetings. When tracking project progress in Excel, it is important to provide your boss with concise and relevant information. Here are some recommendations to address your questions:

Daily Project Report: When sending a daily project report to your boss, focus on key updates and highlights. Include information such as completed tasks, milestones achieved, any critical issues or risks, and a summary of overall project progress. It’s not necessary to send the entire project tracker every day; instead, provide a brief overview or summary.

Task Status and Overall Project Completion: If you manually add an extra day to your overall project completion tracker without updating the task status, the completion status will remain unchanged. Task status should reflect the progress of individual tasks, while the overall project completion tracker represents the aggregate progress. To ensure accurate reporting, make sure to update both the task status and the overall project completion tracker accordingly.
Apply the following formula in the Task status column, then drag it down to alter the task status dynamically.
=IF(H2=100%, “Completed”, “In progress”)

Dear CHRIS B.
Greetings. Thank you for your inquiry. I am not quite sure in which step you get the first error. You might be experiencing that issue as a result of improper code application.

Dear JENNI,
Greetings.
According to what I know, there isn’t a way to combine the modules in Excel VBA so that they both function and you can choose multiple items from each column.
The task of selecting multiple items from a data validation drop-down list can be accomplished using the VBA code below.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Value_Old As String
Dim Value_New As String
If Target.Count > 1 Then Exit Sub
If Target.Value = "" Then Exit Sub
If Not Intersect(Target, ActiveSheet.Range("Section_I")) Is Nothing Then
'Section_I is the name of the range of cells of the particular column where you want to choose multiple items, you can change this based on the column.
Application.EnableEvents = False
Value_New = Target.Value
On Error Resume Next
Application.Undo
On Error GoTo 0
Value_Old = Target.Value
If InStr(Value_Old, Value_New) Then
If InStr(Value_Old, ",") Then
If InStr(Value_Old, ", " & Value_New) Then
Target.Value = Replace(Value_Old, ", " & Value_New, "")
Else
Target.Value = Replace(Value_Old, Value_New & ", ", "")
End If
Else
Target.Value = ""
End If
Else
If Value_Old = "" Then
Target.Value = Value_New
Else
If Value_New = "" Then
Target.Value = ""
Else
If InStr(Target.Value, Value_New) = 0 Then
Target.Value = Value_Old & ", " & Value_New
End If
End If
End If
End If
Application.EnableEvents = True
Else
Exit Sub
End If
End Sub

Hello CASSIE,
Greetings. Use Excel VBA to quickly complete your task. In Excel VBA, you can use the following code to only copy the cells in columns A through J (inclusive) rather than the entire row:

Sub CopyColumns()
Dim lastRow As Long
lastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("A1:J" & lastRow).Copy
End Sub

The End(xlUp) method, which locates the final non-empty cell in the column, is used in this code to obtain the last row in column A first. Then, using the Range object and Copy method, it copies the data from columns A to J.

This code can be changed if you want to perform additional operations on the copied data or paste it in a different place.

Dear Deezballs,
Greetings. Usually, it refers to having three sets of data that you want to plot on the same graph when making a line graph in Excel with three variables. In general, using three variables when making a line graph in Excel means you want to see how three different sets of data relate to one another over time or across a range of values.

Hello JORDAN,
Greetings. You can easily change the color of the fill based on the project by following the steps below.
First, double-click on the particular task of the specific project in the Gantt chart. Therefore, the Format Data Point window will appear. Next, in the Format Data Point, you have to select Fill & Line and then choose Solid Fill. Then, you have to enter your required color for the data point. You have to follow the same procedure for the other tasks in the specific project. You can alter the fill’s color in accordance with the project in this way.

The steps listed below must be followed if you want to instantly change the Gantt chart’s color.
First, click on the task of any project in the Gantt chart. Therefore, the Format Data Series window will appear. Next, in the Format Data Series, you have to select Fill & Line and then choose Solid Fill. Then, you have to enter your required color for the Data series. Based on the color you enter, this process will create a similar color for the entire Gantt chart.

Hi WOLFIXX,
Greetings. Thanks for commenting. You just need to select Administrative Templates from User Configuration from the Local Group Policy Editor dialog box.

Hi Carrie,
Greetings. Thanks for commenting. Yes, you can change the color scheme by following the below process.
Select the data range where you want to apply Conditional Formatting. Then click as follows: Home > Conditional Formatting > Highlight Cells Rules > Equal To.
Soon after, a Conditional Formatting dialog box named Equal To will open up
Type the name of the Region for what you are looking for duplicates.
Then click on the drop-down icon from the right side of the dialog box and select Custom Format.
Therefore, the Format Cells window will appear, and select the Fill option. Then choose your desired color.
Finally, just press OK

Greetings. You must carry out the subsequent steps if you want to resolve the issue.
When you run the VBA code, you will find a Microsoft Excel prompt box asking you to enter the first date.
Subsequently, enter the date that you want to insert in the first worksheet. Enter it using the DATE function in Excel.
To fix your problem, you have to enter the formula:
=DATE(2022,12,28)
Year, month, and day are shown, respectively, as (2022,12,28).
Next, click on OK.
Now, another Microsoft Excel prompt box will appear that will ask you to enter the increment.
Enter the increment, and then click on the OK button.

Thank you for your question. Yes, you can prepare it on an empty Excel sheet so that it will balance automatically when the figure is entered.

Hello HUYNH LE TUAN,
Thank you for your question. I couldn’t understand your question properly. Could you please provide your Excel workbook? It would be easy for me to solve the code error if you send me a copy of your Excel workbook. You can send your workbook here- [email protected]

Hi GENOBLE,
Your question is greatly appreciated. You can easily fix your error by enabling Excel’s GetPivot Data function. If you want to enable Excel to use the GETPIVOTDATA function when you point to pivot table cells at the time of creating a formula, choose PivotTable Tools ➪ Analyze ➪ PivotTable ➪ Options ➪ Generate GetPivot Data command. Now, you can easily reference a cell on another tab in the main pivot cell.

Greetings, LOIACONO.
I appreciate you asking this question. You have to follow the “3 Shop Scheduling Problem” example from this article. If you wish to do the calculation at a time/hour level instead of a day level, you need to input hours instead of days in the Days needed column. You must then follow the example’s rest of the process to arrange jobs in a way that maximizes machine utilization.

Greetings, Raja.
I appreciate you asking this question. You can find it here “Sequencing problem using Johnson’s algorithm of scheduling n-jobs on 2-machines”