Cheat Sheet
 

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

Hi!

Is there a better way?

Nope!

I do the same thing. There's just too much to try and remember (especially
for long complex formulas).

Biff

"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

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
|
|

Thanks, Rodney! I'll need to use Access.

Linda

"Rodney" wrote in message
...
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
|
|

Ouch!
sounds like overkill :)
MSWorks (Version 4.5a-the Swiss army knife of
Database and Spreadsheet and Word Proc computing)
can be purchased on ebay for about $15
remember to always format the cell/field as text
to enable the formula to be pasted.
Good Luck.







"LMB" wrote in message ...
| Thanks, Rodney! I'll need to use Access.
|
| Linda
|
| "Rodney" wrote in message
| ...
| 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
| |
| |
|
|
|
|