Forum Widgets
Latest Discussions
I need help create a pdf with a button
Private Sub CREATE_GARY_TEAMS_PDF_Click() Dim FilePath As String ' Specify the output file path FilePath = ThisWorkbook.Path & "\GARY NFL TEAMS SCHEDULE.pdf" ' Select the sheets you want to export as ONE PDF Dim SheetArray As Variant SheetArray = Array("STEELERS FOR FRIENDS", "CHARGERS FOR FRIENDS", "RAIDERS FOR FRIENDS", "COWBOYS FOR FRIENDS", COWBOYS FOR FRIENDS" , COWBOYS FOR FRIENDS""EAGLES FOR FRIENDS", "BEARS FOR FRIENDS", "49ERS FOR FRIENDS", "49ERS FOR FRIENDS", "CARDINALS FOR FRIENDS", "RAMS FOR FRIENDS") ' Ensure sheets exist before proceeding Dim ws As Worksheet, i As Integer For i = LBound(SheetArray) To UBound(SheetArray) On Error Resume Next Set ws = ThisWorkbook.Sheets(SheetArray(i)) If ws Is Nothing Then MsgBox "Sheet '" & SheetArray(i) & "' not found!", vbExclamation, "Error" Exit Sub End If On Error GoTo 0 Next i ' Export sheets as a single PDF ThisWorkbook.Sheets(SheetArray).Select ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=FilePath, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=True ' Deselect sheets to prevent selection issues ThisWorkbook.Sheets(1).Select ' Adjust to a default sheet MsgBox "PDF saved at: " & FilePath, vbInformation, "Export Complete""" End Sub Steelers Chargers Raiders Cowboys x3 Eagles Bears 49ers X2 Cardinals Rams I have a worksheet called Button on that is enabled. I need help adding 2 more Cowboys. button. I tried putting a button worksheet in a PDF. file, I do not want that Thanks Yousf49ers19238597Jun 14, 2025Iron Contributor73Views0likes5CommentsConditional formatting for row based on one cells value compared to 2 other cells
I’ve attached two pictures of a sales report. The black and white is what I’m starting with and the colored version is the goal (currently coloring it manually) I need the row to highlight a certain color if the data in column i of that row is less than the cell next to it (column J), or a different color if it’s greater than or equal to another cell (column k). Is this possible to do without having a different rule for each row? If so, how?The_lich_adventurerJun 13, 2025Occasional Reader28Views0likes3Commentsexcel changing input values
need help anybody i have worksheet for jobs with varying job numbers but need to sum up the man hours spent on a job like the one shown below. the job numbers in all rows are changing during input and i need to tally all the hours spent in a specific job/s. i called it job manhour, accumulated manhr spent on a job. can somebody give me idea on how to do it best pls....0720Jun 13, 2025Copper Contributor111Views0likes9CommentsSensitivity
I have a question regarding the table in cells J4:N8. The table somehow does not change the numbers even when column I % is different and row 3 also. Please can you tell me what I am doing wrong in this context? Thank you. HansVogelaarMaddy1010Jun 13, 2025Copper Contributor83Views0likes11CommentsThe Dreaded "Duration" bug
Hi! I have today created an Excel file (from CSV) using data from our core system which deals with login/logout dates and times, and then durations based on the system usage in between. I have done the necessary splitting of date/time fields into date fields and time fields; and all the source data is formatted as "Text" so appears like floating point numbers. When I pivot the data, it retains the text format. I then select the body of the pivot table, and set the format to {CUSTOM} [hh]:mm:ss which SHOULD be a bare "duration" style format. It displays as that in the pivot table - but if I select on some of the cells, in the formula bar it displays DD/MM/YYYY HH:MM:SS format. On others, it retains the duration without a date. It's infuriating. When I check "Format Cells" no date codes are present; and yet here they are in the formula bar. This means that when I try to USE the data, it is garbage - I get no useful results. I'm stuck. I can't proceed. How do I fix this? Is it an Excel bug?StonelaughterJun 13, 2025Occasional Reader39Views0likes3CommentsExcel search box not returning hyperlink
Hi All, Need help to show the hyperlinks when using the search function on my spreadsheet. I followed a tutorial to create a search box on excel using the 'Filter' Function. using this formula: =FILTER(Table1,ISNUMBER(SEARCH(B4,Table1[Supplier]))+ISNUMBER(SEARCH(B4,Table1[Range]))+ISNUMBER(SEARCH(B4,Table1[Supplier Colour])),"No Match") Column B shows uses the Hyperlink function so products can be quickly viewed. However when using the search box on the search on the other sheet the results the hyperlinks are not preserved Is there a way to preserve the hyperlinks when using the search box any help will be greatly appreciated Thanks28Views0likes3CommentsMacro Formula Relative Referencing
Hi there I am trying to create a macro to use at the end of every month to convert a report into a format the client requires. The amount of rows in the report will differ every month so using relative referencing. I cannot figure out how to get the formulas in Cells G2 & H2 (which I have added while creating the macro) to reproduce regardless of the amount of rows in the report? They always stop at row 14. Thanks for any help. Sheet attached. Quit new to this. Microsoft® Excel® for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20102) 64-bit PC Windows 11 BusinessSusan1085Jun 13, 2025Copper Contributor49Views0likes4Comments264 nested IF statements -- alternative?
Apologies if this is a duplicate entry. I can't seem to find what I thought I posted earlier. I'm looking for alternatives to using LOOKUP when there are numerous nested IF statements. Please see attachment with a screen shot of part of my data. I have 264 individual tables of data based on specific characteristics (age, education, etc.). Each table has 2 columns: score X, score Y. I'd like to be able to pull the t-score (right column) based on the scaled score (left column) depending on the characteristics I select. For example, if A1 is someone's age and B2 is someone's years of education, etc, I'd like to pull the data from the table that matches those characteristics. If I had only a handful of tables, I could use something like: =IF(AND(A1<34,B2<9 [etc. for other characteristics]),LOOKUP(D2:E21),IF(AND(A1<40,B2<9 [etc. for other characteristics]),LOOKUP(H2:I21), .... however, I know this will not work because I have 264 different tables/combinations of characteristics. Appreciate any recommendations. Thank you!Solvedgetcracken801Jun 13, 2025Copper Contributor169Views0likes10Comments
Resources
Tags
- excel42,812 Topics
- Formulas and Functions24,842 Topics
- Macros and VBA6,436 Topics
- office 3656,075 Topics
- Excel on Mac2,665 Topics
- BI & Data Analysis2,397 Topics
- Excel for web1,935 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,654 Topics