why do you link the spreadsheet data
Answers
Answered by
12
Huiii
Your answer is
When we link data, we tell Excel to display data from another worksheet. The worksheet that has the data is the source worksheet and the sheet that wants the data is the destination worksheet. We tell Excel what data to bring forward with a link formula. The link formula syntax is =SheetName!
Hope it will help you
Answered by
14
Why Link Spreadsheet Data? Creating links, or external cell references, can eliminate having the same data maintained in multiple sheets. This saves time, reduces errors, and improves data integrity. A Sales Manager can have a detailed sheet for each rep, and a summary sheet to compare performance.
Similar questions