hopefully your answer can be found here
Excel Tips and Tricks - How to Automatically Download Index Data from NSE - Part OneTo automatically copy data from one Excel sheet to another, you can use formulas or Excel's built-in features. For example, you can use the =Sheet1!A1 formula in the target sheet to reference a specific cell from the source sheet, allowing it to update dynamically. Alternatively, you can utilize Excel's Power Query feature to import and transform data from one sheet to another automatically. For more complex automation, consider using VBA macros to copy data based on specific conditions or triggers.
An embedded chart.
Excel Checker is an Excel add-on that can find every occurrence of cells containing Data Validation or Conditional formatting and list them out on a separate sheet.
no only data can be sort from the excel sheet.. not in the file
how to create a excel sheet
Pfa the excel sheet
A chart sheet just shows a chart by itself, so you don't see the data and there are no rows and columns visible.
Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21
Add a sheet
They are the same thing, excel is Microsoft's spreadsheet programme.
The data sheet view in Microsoft SharePoint is a useful tool for quickly editing several list items. It functions similar to an Excel spreadsheet and can be exported to or imported from an Excel spreadsheet.
To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter the equal "=" sign. Then go back to sheet 1 and the source cell and press Enter.