Topic Options
#3536 - 07/22/03 03:14 PM Editing statements in Financial Reporter
bd Offline
Adagio Guru

Registered: 11/29/01
Posts: 102
Loc: Peterborough, ON
When I was editing statements (Yes, under maintain financial reports) I tried copying a cell from 1 statement to another, it copied the value. Is there some special way to copy the formula?

Top
#3537 - 07/22/03 04:00 PM Re: Editing statements in Financial Reporter
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello bd,

If you are copying the formula from a single cell, the fastest way is to copy the text from the formula bar. That is, click on the cell to get the formula displayed in the formula area, then drag the highlight over the text there with the mouse and press ctrl-c (or right mouse click and select Copy). Go to the cell where you want the formula, and paste the formula into the formula bar.

If you are trying to copy the formulas from the whole sheet, use the following process:

  • Use Edit | Replace and change all occurences of = to '=
  • Select the whole sheet by clicking in the top left hand corner
  • Copy the cells
  • Change to the sheet where you want the formulas
  • Paste the cells
  • Use Edit | Replace to change all occurrences on the sheet of '= to =

Does that help?


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 193 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14484 Topics
70731 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31