Thread: Cheat Sheet
View Single Post
  #3   Report Post  
Rodney
 
Posts: n/a
Default

G'day Linda,
I use Excel alongside MSWorks,
and keep an easy peasy Database for all my Formulae in Works.
I have 4 fields: date, Formulae, what platform works or excel, db or ss
and the basic adaption of the formula

In my Works Database I have 230 fields. with a great majority
with formula, and I find this is an easy way
to copy and paste between platforms, and when I need to
adapt similar requirements.

HTH








"LMB" wrote in message ...
| Hi Guys,
|
| I don't use excel for really complicated things and don't set up sheets
| frequently but when I do make a sheet I want a quick way to copy and past
| the formulas that I have used in the past. Since I don't do it very often,
| is there already a method that you use? Here is an example below of what I
| was thinking of. I concatenate text often so this is my first idea on how
| to keep track. I created an excel sheet so I can go copy the formula then
| change the cell letters to fit what I am working on at the time. Is there a
| better way?
|
| Thanks,
| Linda
|
|
| Expression Outcome
| =A1&" "&B1 A1String B1String
| =A1&", "&B1 A1String, B1String
|
|