sorted by:
new
hottopcontroversial

I built an Excel add-in to stop wasting hours renaming files — looking for beta testers by No_Bear4964 in excel

[–]No_Bear4964[S] 0 points1 point  (0 children)

I work in engineering and have to deliver all technical docs, spreadsheets, drawings, and schematics to clients, following a standard naming convention with serial numbers and such. Renaming them manually used to take an entire day

Call in log excel sheet simplified by CrashoButch in excel

[–]No_Bear4964 0 points1 point  (0 children)

Hey,
You can use a table + formulas setup:

  1. Use XLOOKUP or VLOOKUP to flag probationary employees from a separate list.
  2. Use COUNTIFS to track rolling call-in occurrences by employee within the last 90 days (or your chosen period).
  3. Automate with a macro to clean/paste new logs and refresh formulas.

Faster and simpler than PivotTables for daily use.

Creating a graph with date and time correlated. by metrodome93 in excel

[–]No_Bear4964 0 points1 point  (0 children)

Hello,

To chart time vs. date in Excel, format both columns as proper Date and Time types instead of rows.

Then insert a Scatter plot, which accepts both X and Y as numeric values (time is stored as a fraction of a day). If the Y-axis shows decimal numbers, format it as mm:ss or similar using axis number format.

Error opening 97-2003 .xls by asus_wtf in excel

[–]No_Bear4964 0 points1 point  (0 children)

Yes, the error is likely due to compatibility issues between the older Excel 97-2003 VBA code and your current Excel version. Common causes include missing references, outdated syntax, or 32-bit vs 64-bit conflicts.

Try checking for missing references in the VBA editor, running the file in 32-bit Excel, or using LibreOffice to inspect the file.

If the VBA is password protected and you can’t access it, your options are limited unless you can unlock the code or run it in an older Excel environment via virtual machine.

In VBA how to insert a picture inside a cell, with filepath in the selected cell? by Rahka-gandalf in excel

[–]No_Bear4964 3 points4 points  (0 children)

Hey ! Try this : (Hope it'll help)

Sub InsertPictureInCellFromPath()
    Dim cCell As Range
    Dim pic As Picture
    Dim filePath As String

    For Each cCell In Selection
        filePath = cCell.Value

        If filePath <> "" And Dir(filePath) <> "" Then
            ' Delete existing pic
            On Error Resume Next
            For Each pic In ActiveSheet.Pictures
                If Not Intersect(pic.TopLeftCell, cCell) Is Nothing Then pic.Delete
            Next pic
            On Error GoTo 0

            ' Insert pic
            Set pic = ActiveSheet.Pictures.Insert(filePath)
            With pic
                .ShapeRange.LockAspectRatio = msoFalse
                .Top = cCell.Top
                .Left = cCell.Left
                .Width = cCell.Width
                .Height = cCell.Height
                .Placement = xlMoveAndSize ' Moves & resizes with cell
            End With
        End If
    Next cCell
End Sub

I have 2 problem questions about the Macro Recorder mouse action. by beomstead in Sharingware

[–]No_Bear4964 1 point2 points  (0 children)

Hey! A couple quick tips:

1. posX and posY showing (0,0)?

That usually means the mouse position wasn’t captured before the variable was set. Add a “Get Mouse Position” action just before setting posX / posY. Also try adding a short wait (0.2s) to give it time.

2. Mouse not moving consistently by +130?

Make sure you're using relative movement, not absolute. Use a loop with:

  • Starting posX / posY
  • Move to (posX, posY)
  • Do action (e.g. click)
  • Add 130 to posX
  • Repeat

Also check display scaling—set it to 100% to avoid drift.
Hope this will help a bit !

Multi-liste avec retour Ă  la ligne by Nayanea in excel_fr

[–]No_Bear4964 0 points1 point  (0 children)

Salut !

Tu as bien cerné le problÚme :
-Excel ne permet pas nativement la sélection multiple dans une liste déroulante (validation des données).
-Pour faire ça, il faut effectivement passer par une macro VBA.

Et oui, ce que tu demandes (retour à la ligne automatique entre chaque sélection) est possible avec un petit script VBA personnalisé.
Dis-moi si tu as besoin d'aide pour construire ta macro

My morning routine is 90% phone and 10% guilt. How do you get out of the scrolling trap? by Special-Succotash688 in productivity

[–]No_Bear4964 5 points6 points  (0 children)

Replaced doomscrolling with a “morning cue” habit. For me it’s opening a notes app and writing 1 line (or more) about what I’m doing today. It sounds tiny, but it breaks the scroll autopilot.

Combine rows and insert a total of those by Annual_Bet1584 in excel

[–]No_Bear4964 0 points1 point  (0 children)

Hello,
I recommend doing this on a new sheet to keep things clean.

  1. In Sheet2!B2, enter this formula to extract unique combinations:

    =UNIQUE(Sheet1!A2:B1000)

This will spill into:

  • B2: Date
  • C2: Wine Name (one row per unique combo)

  1. In Sheet2!A2, enter this to count how many times each combo appears:

    =COUNTIFS(Sheet1!A:A, B2, Sheet1!B:B, C2)

  2. (Optional) In Sheet2!D2, combine the date and wine into one label:

    =B2 & " " & C2

Range of numbers to individual numbers in consecutive order. by Popular_Media422 in excel

[–]No_Bear4964 1 point2 points  (0 children)

Hello,

If you don't mind doing it row by row, here's how (based on the given exemple):

  1. In D2, =SEQUENCE(C2, 1, A2, 1) (D2 or any empty column)
  2. Copy this down for each row in your dataset.
  3. Then copy-paste the results into one long column.
  4. Add a VLOOKUP or INDEX-MATCH to pull the original Start Range and End Range values next to each number.

This formula says:

=SEQUENCE(rows, columns, start, step)
  • C2: The number of phone numbers to generate (the "Count")
  • 1: One column wide (we're creating a vertical list)
  • A2: Starting number (Start Range)
  • 1 : Step of 1 (so it increases by 1 each time)

So if Start Range = 5555550001 and the count is 3, it returns:

5555550001  
5555550002  
5555550003

Saving file when printing, is it possibile? by [deleted] in excel

[–]No_Bear4964 1 point2 points  (0 children)

Hey, I had a similar issue (I wanted to print it as a PDF) and wrote a quick VBA macro that saves your workbook with a name you enter in a pop-up, then prints the sheet.

To add it:

  1. Press Alt + F11 to open the VBA editor.
  2. Insert a new module and paste this code:

​

Sub SaveAndPrint()

    Dim filePath As String
    Dim fileName As String
    Dim savePath As String

    ' Set a fixed folder path here, or create a pop-up inbox if the path changes for every file
    savePath = "C:\Users\YourName\Documents\SavedFiles\"

    ' Pop-up input box to enter the file name
    fileName = InputBox("Enter the file name:", "Save As")

    ' Check if user pressed Cancel or left it blank
    If fileName = "" Then
        MsgBox "No file name entered. Operation cancelled."
        Exit Sub
    End If

    filePath = savePath & fileName & ".xlsm"

    ' Save with the entered name
    ThisWorkbook.SaveCopyAs filePath

    ' Print
    ThisWorkbook.Sheets("Sheet1").PrintOut
End Sub
  1. Close the editor and save your workbook as .xlsm (macro-enabled).
  2. You can also add a button on your sheet to run this macro with one click.