I like the comprehensive explanation. It helps so much in understanding how it works.
@SessionsbySaurabh
9 ай бұрын
Thanks a lot for your words.
@wejrd_
Жыл бұрын
Thank you for this tutorial. After looking for solution for my problem for about 4 hours today, you explained everything about tables for me in 15 minutes. Impressive.
@SessionsbySaurabh
Жыл бұрын
Thanks a lot for your words.
@stanTrX
Жыл бұрын
Very helpful, thank you 😊
@SessionsbySaurabh
Жыл бұрын
Thanks
@cidscala
Жыл бұрын
Excellent! Congrats, professor!
@SessionsbySaurabh
Жыл бұрын
Thanks
@ezSpinMan
6 ай бұрын
Thank you for clearly explaining some of the mysteries of tables! How do you go about finding which column “Age” is as a variable and then using the variable in the code?
@SessionsbySaurabh
4 ай бұрын
Hi, use below code to find “Age” column Dim mytable As ListObject Dim col_no As Integer Set mytable = ActiveSheet.ListObjects("myTable") 'To get the column number of "Age" column col_no = mytable.HeaderRowRange.Cells.Find("Age").Column 'To select the age column mytable.ListColumns(col_no).Range.Select
@iliesmeziani
11 ай бұрын
Merci beaucoup c'est très utile
@bob-tina
Жыл бұрын
Heel duidelijk uitgelegd. dankjewel
@SessionsbySaurabh
Жыл бұрын
Thanks Bob
@relaxingtown4all440
3 жыл бұрын
Excellent and very easy. thank you
@SessionsbySaurabh
3 жыл бұрын
Thanks. Your words made my day.
@relaxingtown4all440
3 жыл бұрын
@@SessionsbySaurabh I joined your channel because I like your step by step method. easy understandable. can you please explain how to add a linked chart to a database table in a VBA form
@Micuamacu1
Ай бұрын
HI.... IT IS POSSIBLE TO REFERENCE COLUMNS DATA USING TABLE HEADERS INSTEAD USING COLUMNS NUMBERS? THANKS
@SessionsbySaurabh
Ай бұрын
Yes, you can. mytable.ListColumns(“Age”).Range.Select will select the column having header name “Age”.
@andyv123
Жыл бұрын
Very useful. Thanks. Is there a quick way to append data to a data table. I.e combine two tables together? Very inefficient to add row by row and column by column
@SessionsbySaurabh
Жыл бұрын
To copy data from one table to another, we can use below VBA. Let me know if It resolves the issue. Hope I understood the problem correctly. Sub copyDataFromAnotherTable() Dim myTable As ListObject Dim newRow As ListRow ''''''''mainTable is table name. Set myTable = Worksheets("Sheet1").ListObjects("mainTable") Set newRow = myTable.ListRows.Add '''''''''''''copy data of table. TableToCopy is table name. Worksheets("Sheet2").Range("TableToCopy").Copy '''''''''Paste the data in new row newRow.Range.PasteSpecial xlPasteValues End Sub
@stanTrX
Жыл бұрын
Thanks again, one question, why shall we define the table in activesheet, what happens if its in a different worksheet. Is there a way to call it without referring it's sheet number?
@SessionsbySaurabh
Жыл бұрын
Hi StanTR, you can call any sheet as below: Set mytable = Sheets("data").ListObjects("myTable") here, "data" is sheet name which contains the table and "myTable" is table name.
@anshuljain6127
3 жыл бұрын
This is going to help a lot
@SessionsbySaurabh
3 жыл бұрын
Thanks
@TheJaebeomPark
9 ай бұрын
interesting! thanks
@SessionsbySaurabh
9 ай бұрын
Thanks
@kamranmammadov9546
Жыл бұрын
Thanks for the information. Can you help to pass the data in the listbox to the table? Thanks in advance
@SessionsbySaurabh
Жыл бұрын
Hi, I uploaded a file where user form is used to add/update/delete data from table. Please check if it helps you. drive.google.com/file/d/1p3YAcnYiLXJIrWYgz5XziTQ0R2Zrw7mz/view?usp=sharing
Пікірлер: 30