to insert a table in Excel sheet that shows the data from a datasheet?

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

to insert a table in Excel sheet that shows the data from a datasheet?

Post by BittenApple »

Hello team,
Can we insert a table on a sheet which references other sheets and the table is being shown as a scrolling table?
Please advise me.'
Regards,
Guity

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: to insert a table in Excel sheet that shows the data from a datasheet?

Post by HansV »

You can create a formula in a table column that refers to cells on other sheets.

What do you mean by "a scrolling table"?
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: to insert a table in Excel sheet that shows the data from a datasheet?

Post by BittenApple »

Hello Hans,
I mean table is operated by a scroll bar.
Thanks,
BittenApple

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: to insert a table in Excel sheet that shows the data from a datasheet?

Post by HansV »

Tables don't have a scroll bar; you have to use the scroll bar of the Excel window.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: to insert a table in Excel sheet that shows the data from a datasheet?

Post by BittenApple »

Thanks,
I will.
Blue in the sky!!!