creation

  1. E

    Automatically populating/removing rows in a table based on the values of another table

    Hello, I'm very new to this forum, just created an account because I've been googling for hours and I can't find a solution to my problem. Hope someone here will be able to help me. I have a 1st table, called "IDStatusSettings" in Sheet 1: This table is displaying datas from other sheets in...
  2. S

    Run time combobox creation with afterupdate

    Hi, i am curikus whether it is possible to set a macro for afterupdate action for created in runtime combobox? I get an error for not supporting such operation: ...'creation of cb on button click MyCB.afterupdate = "mymacro"
  3. S

    Automate creation of event macro

    Hi, So I have a monthly report that I have automated to refresh with new data and perform other preparations. One tool I have will cause the header to change color if filtered. That way I don't forget the filter and allow it to mess up the rest of my work. I want to add the creation of this...
  4. P

    Compile Error: Variable Not Defined

    Howdy, I have used this code before for other sheets in my workbook. I changed the name to be the new worksheet and adjusted the code throughout my workbook to include the new worksheet. I get the Compile Error: Variable Not Defined when ever I point to the Set wsIBMass (new worksheet). I am...
  5. D

    Formula for creating hyperlinks

    I have a spreadsheet "Student Data Directory 2013-14.xlsx" where column C is LastName and column D is FirstName. I have folder /Volumes/SHARED/FANNON_JOBS/34899_EHS Directory 2013/Originals/Directory Second Submission/Photo where the files are named "lastname firstname.jpg". What is the formula...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top