Aung Shine

Hello, thanks for reaching out.

I am not sure which step you’re referring to. If it’s the first drop-down under the Edit the Rule Description, please choose Format only cell with: Cell Value from the options. However, you should see that being selected by default.
Kindly let us know your further queries.

Regards,
Aung
ExcelDemy

Thanks for reaching out.

Suppose, the technician’s name is Jim. You can follow method 1 of this article to manually copy the row after applying a filter for Jim. Then you can paste it in the sheet for Jim.

You can also follow sub-method 2.2 of method 2 of this article to apply VBA to perform your task. In the code, you just have to change the sheet names according to your requirement. You should also modify the range to look for the technician name: in your case it’s column D.
Suppose, the main sheet name is Sheet1 and the destination sheet name is Jim, our technician. The code will be:

Sub MoveRow_KeepOriginal()
Dim rg As Range
Dim xc As Range
Dim p As Long
Dim q As Long
Dim r As Long
p = Worksheets("Sheet1").UsedRange.Rows.Count
q = Worksheets("Jim").UsedRange.Rows.Count
If q = 1 Then
If Application.WorksheetFunction.CountA(Worksheets("Jim").UsedRange) = 0 Then q = 0
End If
Set rg = Worksheets("Sheet1").Range("D1:D100" & p)
On Error Resume Next
Application.ScreenUpdating = False
 For r = 1 To rg.Count
 If CStr(rg(r).Value) = "Jim" Then
 rg(r).EntireRow.Copy Destination:=Worksheets("Jim").Range("A" & q + 1)
 q = q + 1
End If
Next
Application.ScreenUpdating = True
End Sub

This code should do the work. You can try this by changing the technician name. Hope this helped.
Regards,
Aung
ExcelDemy

Thank you very much. This article shows how you can pull data from different worksheets present in a workbook. However, if you want to extract data from sheets present in different workbooks, kindly go through the article linked below. It will guide you through the complete procedure.

https://www.exceldemy.com/excel-macro-extract-data-from-multiple-excel-files/

Moreover, you can create a simple formula:

=’D:\SOFTEKO\[task_problems.xlsx]Sheet1′!$C$18

Where D is the drive location, SOFTEKO is the folder name, task_problems is the desired excel file, Sheet1 is the worksheet, and C18 is the required cell value.

Here, make changes according to your requirements.

Good luck.

We’re very glad to hear that we could be of help to you as well.

Good luck.

We’re happy to help you out. Kindly refresh the worksheet if you change the cell colors. You’ll find the Refresh button in the Data tab. However, if we can improve the code to update it automatically, we’ll let you know.

Good luck.

Thanks for reaching out to us. Please go through the article linked below. I believe that will help to solve your issue. You can also mail us your Excel file at [email protected] and state your conditions.

https://www.exceldemy.com/merge-two-columns-in-excel/

Good luck.

Thanks for reaching out. Kindly mail me your Excel file and queries at [email protected]
I’ll be happy to help.

Welcome ASIM, glad we could help you.

Hello SHERRY,

This is Aung, one of the writers/developers in ExcelDmey. Thank you for pointing out the issue. We have re-uploaded the excel file. Now you can download it without any problem.

Good luck.

Hello BRYAN,

This is Aung, one of the writers/developers in ExcelDmey. I’ve looked into your matter. What you need to do is just modify your formula. Choose any one from the below 2 formulas:

=SUMPRODUCT(AA3:AA43,(–(TEXT(I3:I43,”mmmm”)=TEXT(B1,”mmmm”))))

=SUMPRODUCT(AA3:AA43,(–(MONTH(I3:I43)=MONTH(B1))))

Both should work perfectly fine.

Good luck.

Thank you ROGER for reaching out to us. Sure you can send me your files at my mail: [email protected]
I’ll be happy to help you.

Hello SHAWN,
Thank you for letting us know your queries. Yes, there’s a way to attach a button to run your desired macro. Just insert any shape (Insert > Illustrations > Shapes) in the worksheet. Then, right-click on the shape to get the Context Menu. There, select the Assign Macro option. Hence, it’ll return a dialog box. Choose your desired macro and press OK. In this way, you don’t have to go to the VBA window to press the Run key.
Hope you can perform the task. Please reach out to me at: [email protected] for further queries.
Good luck.

Hello JKS,
Thank you so much for pointing out the mistake. We’ve uploaded the accurate VBA codes in methods 2 & 3.
And about your other issue regarding the screenshots, the codes are really long. That’s why we have demonstrated the upper portions only. But the entire code is there.
Lastly, we are grateful for your feedback. It helps us to grow.
Good luck.

Hello DARRYL,
I’m not sure what you tried to mean by missing colors. The Headers are still blue in the email body. Please reach out to me at: [email protected] for any further queries. I’ll be happy to help.
Good luck.