Cheat Sheet

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

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




(e-mail address removed)



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



(e-mail address removed)



| Thanks, Rodney! I'll need to use Access.
|
| Linda
|
| | > 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
| >
| >
| >
| >
| > (e-mail address removed)
| >
| >
| >
| > | > | 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
| > |
| > |
| >
| >
|
|
 
Back
Top