This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In sheet 1 I have today's date and weightage of each stocks in a portfolio. Weight is calculated using a set of formulas. Each day the weightage of each stock might change. Hence in sheet 2 I would like to record the weight of each stock as on that date, so I could keep a track of what was the weight as on a particular date. Is there any way Sheet 2 could be updated automatically.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Formula cannot read a data which is not exist in your sheet.
You need at least one of the actions erveryday.