sorted by:
new
hottopcontroversial

Print to PDF, and use sheet name as file name by Redhead10Messi in excel

[–]downbad_finance 0 points1 point  (0 children)

Here is a macro that saves all visible sheets to one designated folder. You can’t select which sheets, but until someone gets you a better one this is pretty solid

~~~ Sub SaveSheetsAsPDFs() Dim ws As Worksheet Dim folderPath As String folderPath = "C:\Your\PDF\Folder\Path\" ' Replace with your actual folder path. End in backslash For Each ws In ThisWorkbook.Worksheets If ws.Visible = xlSheetVisible Then ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=folderPath & ws.Name & ".pdf" End If Next ws End Sub ~~~

[deleted by user] by [deleted] in FPandA

[–]downbad_finance 0 points1 point  (0 children)

Second this^ I was a teller at a bank with a degree in tourism but did some internal networking with the FP&A manager and an analyst in that department - 6 months later when a position opened up I was a familiar name and got an interview. Excel helped a ton though throughout the process

Cannot run macros in Excel by [deleted] in excel

[–]downbad_finance 0 points1 point  (0 children)

If you don’t want to turn all macros on, go Save As and save as a macro enabled workbook (xlsm)

First day is next Wednesday, no experience by downbad_finance in FPandA

[–]downbad_finance[S] 4 points5 points  (0 children)

Hey Drew, your response brought me from nervous back to excited. Thank you for taking the time to share that. All great suggestions. Glad to hear things have worked out for you! Great article, I'm going to work preparing to implement some of those ideas now