Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Formulas vs. VBA
Hello,
I have an excel workbook that has a worksheet that consists of 30 columns with 1000 rows. One of my main columns of input is the Admit Date of a Patient. From the Admit Date, various Due Dates are generated at specific points in time (ie.14 days, 30 days, 60 days etc) So, I would have a formula as follows - =IF(AND(Patient_Name<"",Admit_Date<""),Admit_Dat e+30,"") My question is, which direction is more efficient - 1) Creating formulas that are copied for 1000 rows or 2) Creating VBA code that only enters the result once an input has been entered in the Admit Date column. I am trying to figure out ways to reduce my 10 Mbs excel workbook. Thanks Ruan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two formulas in on cell based on two numbers in another cell? | Excel Discussion (Misc queries) | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |