Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-25-2020, 04:26 PM
Ricko_uk Ricko_uk is offline link tables across spreadsheets Windows 10 link tables across spreadsheets Office 2019
Novice
link tables across spreadsheets
 
Join Date: Aug 2020
Posts: 10
Ricko_uk is on a distinguished road
Default link tables across spreadsheets

Hi,
I have Spreadsheet A and Spreadsheet B.

They are 2 separate files always in the same file location and always inside the same folder. Spreadsheet A is always called "Spreadsheet_A" and Spreadsheet B is always called "Spreadsheet_B".



I want to implement the following but haven't yet found a way:

1) have a table in Spreadsheet A named "Table_1" to appear in Spreadsheet B when I open it

2) it must be automatic so no copy paste, no import or any other operation like that. Just some kind of dynamic link of some sort?? So whenever I open Spreadsheet B whatever is in Table_1 appears there without me doing anything.

3) if I change the data in the original table ("Table_1" on Spreadsheet A") the data is automatically updated in Spreadsheet B. That includes if the number of rows in Table_1 increases or decreases (columns are always the same and with the same name).

Anybody can help?

Thank you
Reply With Quote
  #2  
Old 08-25-2020, 09:39 PM
Purfleet Purfleet is offline link tables across spreadsheets Windows 10 link tables across spreadsheets Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

So the same as yesterday then


https://www.msofficeforums.com/excel...eets-into.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link parts of excel spreadsheets in powerpoint and change source of links ahet PowerPoint 0 10-05-2016 01:37 AM
link tables across spreadsheets Link Tables in multiple documents Stormie Word Tables 4 05-24-2016 06:53 PM
link tables across spreadsheets Merging Two Spreadsheets buechler66 Excel Programming 1 03-25-2015 11:57 AM
link tables across spreadsheets Can't open spreadsheets kaygeea Excel 7 10-05-2011 08:00 AM
link tables across spreadsheets Merging two spreadsheets BrazzellMarketing Excel 5 04-26-2011 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft