populate

Hi All, I have created the below macro that will populate a value in 1 specific cell based on 1 specific cell in a different column. My question is how do I look at the entire column for that word and populate the other word down a different column Any help would be much appreciated! Sub...

Hi, I put trough this programme to copy information form B10:W10 and populate that into the next empty line. I just don't know how to write that down to make it work. Can you please help me with that? Thanks Sub PopulateLine() ' ' PopulateLine Macro ' ' Range("B10:W10").Select...

I have a workbook with a lot of data. The data is in about 100 different, 1 collumn tables with unique names. Then i have different userforms with comboboxes in it. I want to populate the comboboxes with the data from the different tables, but without referring to sheetnames. In this way I...

I want to populate combobox with the first 3 collums from table1 and the whole table from table2. But I also want my workbook to be dynamic, so I can move the tables around and not affect the userforms comboboxes. So far I have populatet the comboboxes with this code: With combobox1...

good day, I am seeking expert help as stated in the title I have a code but it can only populate single column, I have been searching the net but can't find answer. Hope you could help me... Thank you... Private Sub fPRNumber_AfterUpdate() Dim ws As Worksheet Dim x, dictDim i As Long Dim...

Hi, everything I used to know about VBA I have forgotten, so this simple task is causing me a headache. I want to populate the value of B3 incrementally from the cell right above it IF the value of A3 is the same as A2. ELSE populate as .001 and repeat for B4, and loop until a blank cell is...

Hello all, I am new to this forum, but not new to excel/VBA. I have a problem that I can't seem to work out in my own head, and I believe it's a very simple one which makes it all the more frustrating to me. I have developed rotating shift schedules for my workplace for 6 different...

rules: 60years + 10 years of experience OR 65 years and older. I have DOB in Column P and Hire date in Column Q, and I would like to have column R populate "yes" or "no' Can you please help. Thanks,

Hi All, I trying to work out the formula that would populate a cell with a budgeted amount based on 2 criteria - please can anyone assist? I have attached workbook that has actuals and budget and it is cell AU 4 and5 I need to populate. For ease I have put the budget on same sheet. Thank you...

hi. I need to populate my textbox based on criteria (from another textbox). below is my sample data (Sheet2) <tbody> A B C D E 1 133 ABC OCT-8-2018 12.50 EEE 2 254 HDS SEPT-1-2018 32.50 GGG 3 456 NJH OCT-10-2018 36.12 DDD 4 569 SDF AUG-21-2018 25.00 UUU 5 112 JRT JULY-6-2018 15.00...

Hello, I have a function but when I click the + icon it does not populate across the whole column. Any idea how to fix this please? Thanks

Hi forum I am trying to populate an array in a loop. However, out of inexperience with arrays, I can't seem to populate my array. Dim SuppressArray As Variant i = 1 For Each c In m_wb.Sheets("Componenten").Range(Cells(cell.Row, "N"), Cells(cell.Row, LCol)) If c.Value <> "" And...

This is probably very easy for someone who knows VBA better then me. But what I want to achieve is to populate let say five rows in same column with same number then add one to that number and populate next five rows with the new number and so on, let say do this 100 times (last number is 240)...

Hello, I am trying to populate some data by relying on a table I have named Area_Table. Here is what the table looks like: <tbody> Unique ID Area 1 Area 2 Area 3 Area 4 Area 5 1001 Y N N N Y 1002 Y N N N N 1003 N Y Y Y N 1004 Y Y Y Y N 1005 Y Y Y Y N </tbody> Here is what I am...

In my sample file below I would like to move the details associated with a specific vendor number to a sheet in the same workbook. In my example file for instance lines 3 and 9 are both for the same vendor. I would like the info from those lines to populate the tab titled Jeff's Drywall and...

Hello, So I am looking for the most efficient way using VBA worksheet_change to track cell changes and populate into a column. So say I have cells A1 and A2, when either of them change I want to populate it into another column, say C and D. I will have quite a few of these so looking for the...

Hello: I've been trying to create a formula to get the following info but have not had much luck. I have 2 files and I need to populate the promo price from one file to another based on matching of the item number and then date range See example below <colgroup><col><col><col><col...

Hey Gang! It's been a few years! :) I have a spreadsheet with a start time in cell A2, and a stop time in cell B2. I have 24 columns with the Hour as the header. So column C1 = 1:00 AM, D1 = 2:00 AM etc etc. What I'd like to do is populate the cells under the hours with a '1' for the hours that...

Hello all! Im having a hard time with my VBA. Im attempting to fill column M with who modified the corresponding row. I want the code to populate all the way down. This is my current code. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim rngCell As Range If Intersect(Target...