populating

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...

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...

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...

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...

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...

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...

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

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"...

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: