Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula and data?
Hi all,
I have a database on sheet 2 from wich I fill cells in sheet 1 via a vlookup. The cells in sheet 1 each contains diffrent formulas. Is there any way to get the data via the formulas, edit the results and update the database without erasing the formulas? Thanks for your help. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula and data?
No, a formula can contain either a static value or a formula.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul" wrote in message ... Hi all, I have a database on sheet 2 from wich I fill cells in sheet 1 via a vlookup. The cells in sheet 1 each contains diffrent formulas. Is there any way to get the data via the formulas, edit the results and update the database without erasing the formulas? Thanks for your help. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
DATA VALIDATION - for data which is the result of a formula | Excel Programming |