Lotus to Excell

[Scoop]

I am using Lotus spread sheets and wish to change to Excell. The spread sheet I am using use versions ( Lotus versions )and cover 1200 cells and each sheet has 5 versions and there 7 similar sheets. so for instance I can look at the volume of a given group of parts over 24 months and have different versions predicted sales, actual, production requirement, and each sheet will have a diferent product group. this is used to calculate sales material costs and production times. Can I do the same in Excell

 

[XL-Dennis]

Scoop,

Lotus 1-2-3 has some facilities that XL don´t have, especially the version-utility.

However, a similar tool in XL would be "Customs view" although not so smooth like the version-tool.

Why do You need to change?

Kind regards,
Dennis

 

[Juan Pablo González]

I'm not familiar with Lotus, but, there are two things in Excel that "sound" similar to what you're asking:

- Scenarios

- Track changes