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" <[email protected]> wrote in message
news:[email protected]...
> 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




[email protected]



"LMB" <[email protected]> wrote in message news:[email protected]...
| 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" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>
>
>
> [email protected]
>
>
>
> "LMB" <[email protected]> wrote in message
> news:[email protected]...
> | 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.



[email protected]



"LMB" <[email protected]> wrote in message news:[email protected]...
| Thanks, Rodney! I'll need to use Access.
|
| Linda
|
| "Rodney" <[email protected]> wrote in message
| news:%[email protected]...
| > 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
| >
| >
| >
| >
| > [email protected]
| >
| >
| >
| > "LMB" <[email protected]> wrote in message
| > news:[email protected]...
| > | 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
| > |
| > |
| >
| >
|
|