duplicating

I'm not sure how to ask this without just jumping into the problem... So here it is: I have a table that has door types and corresponding info for said door types. that data is linked to another table that has a drop down. So if you have 3 "Type A"s and 6 "Type B"s, you only need to type the...

Hey all, I am trying to transfer data with this formula =IF(ROWS('Destination Sheet'!$B$5:B5)<=$A$1,INDEX('Reference Sheet'!$B$2:$B$23,AGGREGATE(15,3,('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)/('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)*(ROW('Reference...

Hi there, I'm sure there is a way of duplicating a userform. How do you do this? I just need to make three userforms, all EXACTLY alike. I don't want to take the time to measure it all out and place the buttons all the same. Thanks.

Hi, i'm really new to VBA. i would like to know what should i do for my VBA files if i want to prevent any duplicating data in future. What commands should i use in the macro? for example if i'm doing monthly update data. tq.

Is there a way to duplicate a line based on a value in one of the cells? For example: in columns A through C I have the data that I'd like to duplicate, and in column D I have the number for how many times I'd like to duplicate it. Below is an image of my beginning data. And here is what I'm...

Hello, I have a template I am using where 1 cell drives the entire tab. Instead of copying and duplicating the tab and adding a new name, is it possible to have 10 names in a row and have them generate a new tab for each name?

I am at a loss for how to do this. My current code is simple and displays data only for the latest checked box: Private Sub ComboBox1_Change() End Sub Private Sub CheckBox1_Change() Me.ListBox1.RowSource = "Sheet2!A22:A32" End Sub Private Sub CheckBox2_Change() Me.ListBox1.RowSource =...