Michael has attended:
Excel Intermediate course
Formulas
When copying cells with formulas from one sheet to another, how do i solve this so the numbers come across rather than blank cells?
RE: Formulas
Hi Michael,
Thanks for using the forum.
I suggest you use the Paste special option. Highlight the data you want to copy and click copy and then go to the edit menu and click Paste special and when you get the dialog box come up click "Values" so only the numbers come across.
Hope that helps
Tracy