#1
|
|||
|
|||
Add cells together without a formula?
We take a spreadsheet, make a bunch of formulas, then get a number. We take those numbers, then manually type those numbers over the formula. We do this because we use some proprietary software, so I can't discuss specifics, but it can't read formulas. It can read the numbers, but not the formulas. This is time consuming. I'm in search of a workaround. Something that can copy those numbers into a cell without any formulas.
If this was too wordy, please let me know. I realize there's some information I'm not allowed to discuss. It's work related. |
#2
|
|||
|
|||
I believe your description is clear as you see it ... but it creates a number of questions when we read it.
Can you create a sample workbook. Not the entire thing ... just one sheet with sample formulas / numbers .... and how the sheet looks after you have "typed those numbers over the formulas." Think in terms of a "before and after" example. Provide a description on the sheet what you are doing and where the final numbers go. From that information we can proceed with assistance. |
#3
|
||||
|
||||
Instead of overtyping, you can simply copy the results returned by the formulae and use Paste Special>Values. An entire column or row could be done in a moment.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
||||
|
||||
Yeah, I'm with Paul on this: You can copy a whole range, then paste it over itself with values-only. Depending on your Excel version you get to the Paste-Special dialogue, but I usually just use the old <Alt-E>,S combination that I learned with an older version; my fingers have already memorized it and apparently they've allowed all subsequent versions of Excel to keep responding to it for backward compatibility.
I just had a belated thought, though: Do you really want to wipe out all the work you did typing in those proprietary formulae? They gotta be complicated, after all. Might be easier on you to copy the range and paste the Values to a different workbook; that way you can give the values to the end user without giving away the formulae you're using, yet you can keep the formulae around and reuse them instead of having to retype them. And just to answer your question, yes, you can do it with VBA. But it may not be worth the effort to do that, unless you're doing this many times a day. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula for blank cells | datadummy | Excel | 2 | 09-11-2017 10:19 PM |
Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
Can I pre-populate cells with a formula? | Box | Excel | 1 | 05-03-2014 11:55 PM |
Formula works on most cells | gbaker | Excel | 1 | 04-26-2014 12:31 AM |
Copying a formula that uses pivottable cells | Paul46 | Excel | 0 | 02-08-2014 07:04 AM |