Help needed! share data between worksheets

Hi Darren_Melbs 

Ready to help as best as possible

#1 One thing you should clarify: are you looking at linking info. between Worksheets inside the same Workbook (a Workbook can contain 1 to n Worksheets) or to link info. between 2 Workbooks?

#2 The article you ref. is good, videos sometime help. After quickly watching a few, that one seems good to me. Couple of recommendations if you start from scratch in term of knowledge:

- Do it with local file(s) first. By local files I mean files stored on your PC

- Start with a something very simple: link cell A1 from one Workbook/Worksheet to another and stick to this basic scenario until you get it to work and can easily repeat the process n times

- Don't try to write - by yourself - the external references (i.e. =[WorkbookName]SheetName!...). Only do it with the keyboard and the mouse

#3 When you have it working with local files, the process is the same with files stored on OneDrive or Sharepoint. Assuming you want to link 2 Workbooks:

a) Store the files (without any link between them) on OneDrive/SharePoint

b) Open Excel

c) Go to Open > Nativagate to your OneDrive/SharePoint folder (my OneDrive below)

d) Select the Source Workbook

e) Repeat c-d selecting the Destination worbook this time

... create the link(s) between your Source & Destination workbooks