populating

  1. S

    VBA Userform Populate a Listbox from Table

    Hi, So I am missing the complete obvious here but I am trying to populate a listbox in a userform from an named excel table. I have managed to do this by creating a named range that refers to the table, code A below. But when I am using my userform to delete entries it is crashing out and...
  2. T

    Weeknum

    I have a formula below , where I need the week number from 1 - 13 depending on the upload date & what Qtr we are in. =WEEKNUM(J4058)-WEEKNUM(LOOKUP(J4058,DATE(YEAR(J4058),{3,6,9,12},30))) When a new QTR starts, the weeknum should be "1", however it keeps populating as "0". Any help would...
  3. B

    Populating ListBox with ComboBox selection

    Greetings everyone, I'm trying to populate ListBox1 on my user form with the information in columns A and B from different sheets. For this I have a ComboBox1 containing the names of all sheets in the workbook. For instance, my ComboBox loads "Sheet1", "Sheet2", etc. I want to, upon changing...
  4. C

    Populating worksheet with dynamic # of rows from userform listbox

    Hi, I've been frustrated with this part. I'm trying to population the worksheet with data from a userform. column B is auto-incremented, column D & E are 'most used' debit codes (i only listed 2) and column F is for other debit codes aside from D and E. Column H and I (only listed 2) are most...
  5. D

    Populating a grid

    Hi everyone Im almost a newbie On Sheet1, I have a list of names in column A1 : A100. I would like to put these names into an array and on Sheet2, populate a grid at A1. I also need a message box to pop up to query the dimensions before populating the grid (5x5, 8x10, 8x12, etc) Im trying...
  6. B

    Macro to create worksheets from data in Cells

    I am looking for a macro to copy rows from a spreadsheet and create separate worksheets based on data in Column O keeping the original spreadsheet intact. Data in Column O isn't sorted and changes almost daily so I can't hard code anything. Ex. <tbody> 1 A B H I N 0 2 Defect # Severity...
  7. C

    Populating data from one sheet to another if fields match

    Hi All, I'm hoping someone can help here. I want to write a formula in Sheet 1 J2 that says: If C2 Sheet1 matches with B3 Sheet2 then the number in C3 Sheet2 should populate in J2 Sheet1 Thanks, Calibre16
  8. WaqasTariq

    Populating a ComboBox (ActiveX) using a variable

    I have 100 combo boxes on an excel sheet, they are divided in three sets (1-25, 26-50, 51-100). Each set has the same value within the set, but is different from the other. Right now I am able to populate the combo boxes using the following code ActiveSheet.ComboBox1.AddItem "Value1"...
  9. K

    Populating Excel Calendar with Table of Information

    Hi, I have looked online, but I cannot find anything to help. I have a table of information, but I would like to populate an Excel calendar on the correct date with the subject. Any help regarding this would be much appreciated as I am lost. :eeek:

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
Back
Top