Forum Discussion
Filling data in two different workbooks at the same time
When I enter data into one work book, I would like to auto fill in a different work book that has conditional formatting https://onedrive.live.com/edit.aspx?resid=E6E3D91EA14E1C0F!1349&ithint=file%2c...
If the 'destination' workbook is simply a duplicate of the 'source' workbook, but with different formatting you can link the data in each by way of formula.....e.g. open both workbook and in the destination sheet, cell A1, hit = then switch to the source workbook and click on cell A1 then enter. The formula will look something like this =[Source.xlsx]Sheet1!$A$1
You would then simply copy the formulas down / right and when opening the file you will be prompted to update links, which you would say yes to get the latest data.
You would then simply copy the formulas down / right and when opening the file you will be prompted to update links, which you would say yes to get the latest data.