Help coping formulas

[Bill]

Excell 2007

I have an IF formula for contents in workbook A. I would like to copy the IF
formula into workbook B and have it apply to the contents of workbook B.

Suggestions please.

Thank you,

Bill

 

[CousinExcel]

Does not simply "copy, paste" work ?
If I'm not missing something in your question, it should work.
Cousin Excel

 

[trip_to_tokyo]

1. I have 2 Workbooks set up.

2. In the first workbook in cell C 22 I have the following formula:-

=(A22+B22)

To copy the above formula to cell C 22 of the second Workbook:-

- Ctrl-C in cell C 22 of Workbook 1

3. Now I click in cell C 22 (for example) of Workbook 2 then:-

Home / Paste / Formulas

The above should give you what you want.

If my comments have helped please hit Yes.

Thanks.

 

[Bill]

That does not work. I can copy from workbook A. When I go to paste in
workbook A and hit Paste, I do not get the Formulas option, only the Past
Special option.


Any other suggestions?

Thank you

 

[Bill]

It sounds simple. But copy and paste is not woking for the formula. When I
copy from workbook A, I am only able to copy the "result" of the formula (in
workbook A) to workbook B, but not the formula itself.

Any other suggestions?

Thank you,

 

[trip_to_tokyo]

From Paste Special select Formulas / OK.

Please hit Yes if my comments have helped.

(My first version works OK for me).

Thanks.

 

[Bill]

When I hit Paste Special in workbook B, the Formula option does not appear.
What appears is a menu that shows:

Paste As:
Microsoft Office Excel Worksheet Object
Picture (Enhanced Metafile)
Bitmap
Etc.
Etc.

 

[trip_to_tokyo]

MMMMmmmm, not too sure what's happening at your end.

Are you selecting Home / Clipboard group / Paste / Paste Special?

 

[trip_to_tokyo]

Make sure that you have both Worbooks open at the same time. If you don't
some of the options get greyed out.

Please hit yes if my comments have helped.

Thanks.

 

[Gord Dibben]

You have your two workbooks open in separate instances of Excel which do not
communicate with each other.

Close down one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP

 

[Bill]

Both workbooks are open. Yes, I am using Paste/Paste Special on Clipboard.

Regarding previous post, was there a reason why I was getting that
particular menu (as I described) when I hit Paste Special, instead of the
menu that shows:

Paste:
All
Formulas
Values
Etc.
Etc.

Operation:
None
Add
Etc.
Etc.

 

[rzink]

Bill,

You need to have both worksheet open in the same instance of Excel.

1) Open Excel
2) Open worksheet 1 using open file button
3) Open worksheet 2 using open file button

Then try copying your formula.

rzink

 

[Bill]

rzink:

As simple as it sounds. I tried that but it does not work.

Bill

 

[Bill]

Gord:

Not familar with instances. How do I open the workbooks in a single instance?

Bill

 

[rzink]

Bill,

I believe Gord replied with the same correction as I did. As to "how", see
my orginal post. You must open both worksheet from within Excel. Once you
have worksheet 1 open, go to your quick access toolbar or Office Menu for
2007, or File>Open for 2003 and open worksheet 2. This will open both
worksheets in the same "instance" of Excel.

If this does not fix the problem, then the other option is to copy the
literal formula text from one cell to another.

Select the cell, hit F2, then select all of the formula text within the cell
and hit Ctrl-C. Move to worksheet 2 and select the desired cell. Hit F2 and
then Ctrl-V to past the formula text into the cell. Hit enter to accept and
exit cell editing.

Hope this helps.

Ryan

 

[Gord Dibben]

Close workbook B

then..............

Button>Open>workbook B.

If you double-click on a workbook to open you can create a new instance of
Excel for each workbook you open.

To prevent this behaviour if you don't want it...........

Button>Excel Options>Advanced>General section.

Uncheck "Ignore other applications that use DDE"

If no joy with that then one more step to re-register Excel..............

Close Excel first and On the Windows Taskbar

Start>Run "excel.exe /regserver"(no quotes)>OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK


Gord

 

[grizzly6969]

Try to highlight your formula and after you click copy X out your program and
cancell to save changes --- go to your workbook and left click and paste

 

[grizzly6969]

sorry right click