Home

Excel Spreadsheet - Update data across multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-562313%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%20-%20Update%20data%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562313%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20spreadsheet%20using%20a%20range%20of%20data%20from%20A1%20through%20J100%20with%20cells%20having%20different%20sizes%2C%20data%2C%20text%20and%20numbers.%26nbsp%3B%20Generally%20the%20core%20information%20will%20remain%20the%20same%20however%20I%20need%20to%20be%20able%20to%20utilise%20the%20data%20across%20a%20number%20of%20spreadsheets%20and%20for%20that%20data%20to%20be%20updated%20from%20time%20to%20time.%26nbsp%3B%20So%20I%20would%20like%20to%20know%20how%20to%20set%20up%20the%20spreadsheets%20so%20that%20when%20data%20is%20input%20or%20edited%20on%20Sheet%201%20that%20data%20is%20also%20edited%20and%20included%20on%20the%20other%20spreadsheets.%20That%20is%20through%20Sheets%202%20to%206%20for%20example.%3C%2FP%3E%3CP%3EHope%20you%20can%20help.%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESpencer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-562313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562359%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Spreadsheet%20-%20Update%20data%20across%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562359%22%20slang%3D%22en-US%22%3EYou%20may%20use%20VLOOKUP%20or%20INDEX-MATCH.%20As%20to%20how%20you%20should%20use%20them%2C%20I%20can't%20make%20any%20suggestion%20unless%20you%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E
Spencer739
Occasional Visitor

Hi There

 

I have created a spreadsheet using a range of data from A1 through J100 with cells having different sizes, data, text and numbers.  Generally the core information will remain the same however I need to be able to utilise the data across a number of spreadsheets and for that data to be updated from time to time.  So I would like to know how to set up the spreadsheets so that when data is input or edited on Sheet 1 that data is also edited and included on the other spreadsheets. That is through Sheets 2 to 6 for example.

Hope you can help.

Regards

Spencer

1 Reply
You may use VLOOKUP or INDEX-MATCH. As to how you should use them, I can't make any suggestion unless you attach your sample file.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies