Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pasting a forumla w/o the paste/special/value
Hi,
Is there a function or a way to copy/paste/value a formula once the formula has calculated a number? I don't want to have to manually copy/paste/value. (I'm scraping info from the web, and i just want to grab the values and paste it in a cell.) Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pasting a forumla w/o the paste/special/value
yeah, i could do that, but i didn't want to have to run the macro every few
minutes(its data that comes out every few minutes); also it wouldn't be the same cell that i'm copying/ pasting; it would be like a column of formulas, and i would want to copy paste row by row every few minutes. (i can do simple macros, but nothing too complicated--but i was hoping for a formula or function that could help accomplish this) "NewGuy" wrote: Record a new Macro: Copy the cell containing the formula Paste Special (Value) End Recording. You can either leave it in the Macro folder or create a button and assign the macro to it. - NewGuy "jc3000" wrote: Hi, Is there a function or a way to copy/paste/value a formula once the formula has calculated a number? I don't want to have to manually copy/paste/value. (I'm scraping info from the web, and i just want to grab the values and paste it in a cell.) Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
pasting a forumla w/o the paste/special/value | Excel Discussion (Misc queries) | |||
special forumla | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
How flip a selection before pasting - Paste special | Excel Discussion (Misc queries) |