I have a sheet which has several links to external data. Every time I open the sheet the values are updated.
I would like to display the difference in the values between updates. In other words, prior to update value1 was $5.00, after update it was $5.10. I want to create a cell that shows the difference $.10.
Is there a way to accomplish that??
Thank you,
Klaus Cook
Houston, Texas
[Solved] Working with external data
[Solved] Working with external data
Last edited by MrProgrammer on Sun Dec 27, 2020 10:47 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.1 on Windows 10
- MrProgrammer
- Moderator
- Posts: 4909
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Working with external data
Begin by reading Save old data when web query refreshes.CaseyC wrote:I would like to display the difference in the values between updates.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).