Excel 2016 AutoSort VBA Help!

Hello!

I am having difficulties getting an old autosort code running again. I keep getting an error (end of statement) on each of the commas at the end of each line. I am simply trying to sort a data sheet (A1:T5000) by the values in Column F and then by the values in Column G. Maybe there is an easier way to have this done? Please let me know!

Sub SortMyReport()

Range(“A1”).CurrentRegion.Sort _
Key1:=Range(“F1”), _
Order1:=XLDescending, _
Key2:=Range(“G1”), _
Order2:=XLDescending, _
Header:=XLYes
End Sub

Hmm.. The code finally went through but it did not work. Let me give a bit more background information. I am trying to complete this multi-level sort on "sheet1" of a 5 sheet excel file (not sure if I need to specify the sheet name). Second when the code ran it did not sort how I had thought it would have. The table is the entire sheet (A1:T5000) with Row 1 being the column headings. I am looking to sort Column F and then Column G with this code. And like I said the above code did not work. Any suggestions?

Here is the file that shows the raw data on tab 1 and then the sorted data on tab 2. The screenshot shows the sorting that I want to have done but just automatically with VBA. Keep in mind that I am sorting on descending and DEPENDS will become VERIFY so that it will sort correctly. So Column F would take precedence to Column G. Thanks!!

AutoSort.PNG

Auto Sort File.xlsx

Still does not work. It could be because the sheet I am trying to sort has hlookup formulas to pull data from an "original report dump" tab. Would that interfere? Like you said it works great on the sample but not the actual document. Another thing too could be that the hlookup formulas go from A2:T5000 but the data that gets "imported" has a 'random' end row meaning that it does not fulfill the entire document. There is #N/A's from around the 3500th row to 5000th.

I just figured out the issue. The Hlookups had ROW() as the row index # which was changing when the data was being sorted. I'm solving that by hardcoding the row#s into the formula to then make the formula static instead of dynamic depending on the row that it is in.

No, the sort columns are vlookups. Hence why the sorting is not working due to the vlookups not being dependent on the row that it is within while the hlookups with ROW() is. The Hlookups provide the data movement from the original to edited tab while the vlookups provide a "answer" to the question in the column due to the data pulled from the hlookups. Hopefully that makes sense lol .

I got it to finally work! It was the "ROW()" portion of the hlookup formula. The last thing I can think of is how to make this code automatically run when a cell value changes. Thank you so much for your help!!