Linking formula between tabs

Post your questions, bug reports and suggestions here for PlanMaker 2016 for Windows.

Moderator: SoftMaker Team

Post Reply
spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Linking formula between tabs

Post by spready » Mon Oct 23, 2017 7:08 pm

I've been using Planmaker for 2 months and am very happy with it.

My existing spreadsheets were in .ods format which I converted to .xls to open with Planmaker

Most things went very smoothly but I can't replicate one useful function I previously had.

I frequently use tabs. Let's say I have 2 tabs one named Smith and the other Jones. I can no longer for example find a formula to show in Smith cell A7 the entry recorded in Jones cell B35. It used to be easy using .ods files with other software but all my experiments to date have failed.

I presume there's an easy answer and I'd be grateful to be shown how.

spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Re: Linking formula between tabs

Post by spready » Sun Oct 29, 2017 12:56 am

I'm pleased to say I have now found the answer

Alfred
Posts: 139
Joined: Sat Jun 14, 2014 3:40 pm
Location: Scotland

Re: Linking formula between tabs

Post by Alfred » Sun Oct 29, 2017 2:59 pm

spready wrote:I'm pleased to say I have now found the answer
I'm sure that many PlanMaker users would be grateful if you could share the answer here!
La perfection est atteinte non quand il ne reste rien à ajouter, mais quand il ne reste rien à enlever.
(Perfection is achieved, not when there is nothing left to add, but when there is nothing left to take away.)
- Antoine de Saint-Exupéry (1900-1944)

Post Reply

Return to “PlanMaker 2016 for Windows”