-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
create table
-
B
How can I combine two tables?
Hello - I have two tables across two worksheets. Table 1 has activities/tasks (approx. 200) down column A and named individuals across row 1 (approx. 25) with input data being added into the table, say B2:Z200, so that you can assign one or more named individuals to an activity (and the same...- barcelonat
- Thread
- cost & price create table dynamic array programme sub rows table array table auto generation
- Replies: 5
- Forum: Excel Questions
-
S
VBA issue on creating a table from a copy selection
Hi, I have a pivot table that I'm copying to a new tab to work with as values. The code below is to copy the entire table and paste special to a new tab after the sheet "Inventory Movement". Then paste special a few time to keep the format. Then create a table from the cells and add 2 columns...- shophoney
- Thread
- create table vba
- Replies: 1
- Forum: Excel Questions
-
G
Create a table on another sheet
I am trying to create a table on a different sheet that is not my Activesheet using a button. This is my code so far; the problem area is in between the asterisks. Private Sub CommandButton1_Click() Set srtA = Sheets("Competitor Comparison") With srtA .ListObjects(1).Unlist...- gaudrco
- Thread
- create table end sheet vba
- Replies: 1
- Forum: Excel Questions
-
A
Create SQL table from Excel VBA
Hello - I have the following table in Excel <tbody> SLCo SL CompCode APRef Amount Release 101 19 CM 967 5000 101 19001-01P CM 19001-0719 10500 X 101 123546-A CM 123658-1 15000 X 101 56875-4 CM 9856-7A 7500 X 101 32587-4 CM 5647-8 21500 </tbody> Using VBA on a button, I'd like...- angil0126
- Thread
- create table sql stored procedures table vba
- Replies: 1
- Forum: Excel Questions
-
T
combine 200 workbooks of one format into one table of a different format
Hi. I am a noob! So, apologies if I have missed a post that explain this, as I am unsure of the language to use to describe it. I have 200 questionnaires in the form of workbooks with several sheets. The data is almost all quantitative, percentages or numbers with two decimal places, but there...- trickard1000
- Thread
- automate data extraction combine workbooks create table sheets workbook
- Replies: 0
- Forum: Excel Questions
-
A
Use VBA to Create Table with Unkown Range
I would like to create a table with an unknown range. I currently have the following. Sub Button2_Click() Dim r As Range Set r = Worksheets("Sheet2").Range("A1").CurrentRegion Worksheets("Sheet2").ListObjects.Add(xlSrcRange, Range("A1:B4"), xlYes).Name = "MyTable" End Sub An...- ABlohm
- Thread
- create table dynamic table unknown range vba
- Replies: 2
- Forum: Excel Questions
