If you wish, the data can then be placed into a Word document, an Excel spreadsheet or linked to a database.Īs Bill has suggested, if you would like to make your query a little clearer, there will be someone at this site who can supply a suitable solution to your query. If there is a large range of data, it can be stored in an array. ![]() If you would like to make it a little more complicated, you can place the data into VBA variables so the computer will store the data and place it into your selected worksheets. ![]() Enter your equal sign and click on the other workbook in the status bar and then click on the cell that contains the data to be updated. You can use the same procedure if you want to link to another workbook. If you just want the data to be placed into another worksheet in the same workbook you can reference the cells containing the data with something like =Sheet1!C2 (enter the equal sign and then click on the cells whose values you want to update from automatically).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |