Table Reference

pantakos

Board Regular
Joined
Oct 10, 2012
Messages
158
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hello all,

I have a question. I need to reference to another sheet the value of a cell that is in a table. I need this to be inserted at an other table at the second sheet and expand (show results) along with the first sheet.

Hope you got the idea.

Thank you!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Hello all,

I have a question. I need to reference to another sheet the value of a cell that is in a table. I need this to be inserted at an other table at the second sheet and expand (show results) along with the first sheet.

Hope you got the idea.

Thank you!
I think you need to provide specific details
Like each sheet name and each Table name

You said:
I need to reference to another sheet the value of a cell that is in a table
Nothing specific here.

And you said:
value of a cell that is in a table.
What cell in the Table?
 
Upvote 0
Here is an example of how to put a value into a table named "Alpha" in a sheet named "Master"

VBA Code:
Sub My_Table_Script()
'Modified 11/17/2022  7:35:52 PM  EST
Application.ScreenUpdating = False
Sheets("Master").ListObjects("Alpha").DataBodyRange.Cells(1, 3).Value = "Hello"
Application.ScreenUpdating = True
End Sub
 
Upvote 0
Or to add a new row to a Table and insert a value into that new Table row try this:
VBA Code:
Sub My_Table_Script()
'Modified 11/17/2022  7:50:52 PM  EST
Application.ScreenUpdating = False
Dim ans As String
Dim nr As Long
nr = Sheets("Master").ListObjects("Alpha").DataBodyRange.Rows.Count
Sheets("Master").ListObjects("Alpha").DataBodyRange.Cells(nr + 1, 3).Value = "Mr Excel"
ans = Sheets("Master").ListObjects("Alpha").DataBodyRange.Cells(nr + 1, 3).Value
MsgBox ans

Application.ScreenUpdating = True
End Sub
 
Upvote 0
Solution

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top