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
Highlighted
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
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies