I apologize, I'm not sure exactly what you're asking. I guess the term "value" has thrown me. I'm not sure if "value" is real stuff inside the cell, or the result of the formula.
I want to extract the raw text (formula) from within each cell. If the text (formula) inside a cell is:
=(53+42+55+52+52+54+57+57+56+55+57+51+53+57+46+54+28)/(SUM(Daily!$F$97:$F$113))", then that is exactly what I want to extract out of the cell. The section in red is specificially what I'm after. I need to place those numbers into a database. I'm hoping that there is a more effecient way than double-clicking into each cell, copying & pasting it. I'm needing to extract those numbers from C10:F14. I'm not needing the numbers that the formulas produce. I hope I've explained better than my original post.
Hey, would you mind taking a look another post of mine? I'm seeking feedback at:
http://www.excelforum.com/showthread.php?t=592315
I appreciate your time and willingness to help.
Thanks,
David
Bookmarks