New to VBA and need help please

[Pat1009]

New to the boards here, and new to VBA. I am in search of help with a VBA code that can look through the
“Case Details” worksheet and look for the word “no” in column AL, that also have the following in column AN

US DT/LT MANN M-F 8-5 2/0/8
US DT/LT MANN HUB 9/0/27
US DT/LT DISP MF 8-5 2/0/16
US DEPOT SAN RAMON 2/0/NBD 3C
US SER DISP 5X9 M-F 8-5 2/0/8
US SER DISP SITE 7X24 2/0/8
US SER MANN 5X9 M-F 8-5 1/0/4
US SER MANN SITE 7X24 1/0/4

And when it finds any that meet both of these criteria, to copy the entire row of all the data to the “Missed SLA” worksheet. If it does find any, when it copies the row to the “missed SLA” worksheet, it needs to start on row 3

The column headers in the “Missed SLA” worksheet are not in the same order as the column headers in the “Case Detail” worksheet (this is by design, and must remain that way).
There is also an extra column that was added to the “Missed SLA” worksheet that is not in the “Case Detail” worksheet, it is called “Research” in column G.
That column should be blank after you run the report, but all other columns should be populated.

Is it possible to do this??

 

[hiker95]

Pat1009,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

What you have described sounds doable.

Based on your raw data description, screenshots are probably not the way to go.

3. Can we see your actual raw data workbook containing worksheet Case Details, and, worksheet Missed SLA (manually formatted by you) for the results you are looking for?

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.

 

[Pat1009]

Thank you for your help, I am using Excel 2010, working on a Windows PC
here is the link
https://app.box.com/s/q2bwhomvmbxevfndtv9q5xx2vsavfldx

 

[hiker95]

Pat1009,

I have had a bad experience in the past with downloading/opening a workbook that contains macros.

Please save the workbook without any macros, and, with a file extension of xlsx, and, repost on BOX.

 

[Pat1009]

Ok, new file downloaded.
https://app.box.com/s/kr72h48yf7xnnj6uoawydf7pmt8ebe7z

 

[hiker95]

Pat1009,

I have examined your workbook, and, do not understand what you are trying to do.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Pat1009]

Bump