I am using Ron De Bruin’s code shown below to sort a source worksheet by the Active Cell, create a new workbook, and paste the results in the new workbook (Sort Workbook). The users have asked if the code could also return the row number of the source document so they can find the part number quickly in a worksheet of 1000+ rows. The output that I am hoping for is shown below, the sort is run on the Source Worksheet and the Sort Results would show the sort information to include the row number the data is located on.

Hope this is clear and thank you any and all help
Sort or Filter? The code attached filters not sorts

I'd insert a temporary column in front of the data called 'Row Num", do the filtering, and then insert the row number for the still visible cells, and then copy 4 columns instead of the current three