So I have a macro mostly done with some help from this forum,
Sub Order_Subsets()
Dim SourceRange As Range
Dim DestinationRange As Range
Set SourceRange = Selection
Set DestinationRange = Worksheets("Report").Range("B14")
SourceRange.Copy
DestinationRange.Insert Shift:=xlDown
Application.CutCopyMode = False
Dim ws As Worksheet
Dim File_Name As String
Dim Destination As String
Set ws = Sheets("Report")
Destination = "C:\Users\User\Documents\"
File_Name = ws.Range("D14").Value & ".pdf"
ws.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=Destination & File_Name, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Set ws = Nothing
' Keyboard Shortcut: Ctrl+z
End Sub
So far I have gotten the macro to copy a selection from the "2023" sheet and insert it at a specific point on the "Report" sheet and shift the cells below it down, and then save the sheet to a pdf and automatically name it based on a cell value to a certain location. The final thing I would like it to do is delete the rows that I previously inserted earlier in the macro to clear the "Report" sheet, so that its ready to have the same macro used again with a different selection of data. I don't know if its possible to simply remove the set of data that it inserted previously, or if it would be easier to have the macro go through the "Report" sheet and simply remove any row that contains the string "P-" and then shift the cells below it up. Every row that I would want removed will have a sample id that always starts with "P-" so that would be the easiest way to determine all the rows that need to be removed, I just need it to do that and then shift the cells below the removed rows up. I have been trying to figure out the best way to do this for awhile today and people here probably know far better than I would.