Filling a cell with formula only if cell in the column to the left isfilled

Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Filling a cell with formula only if cell in the column to the left isfilled

Hi,

Is there a way other than VBA for filling a cell with a formula only
if the cell in the adjaced column is filled? The sheet is being used
as a database where new rows will be added periodically. Filling the
whole column with the formula makes the file size very large.

Thanks in Advance for all the help.

Regards,
Raj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling a formula down-need correct cell reference	NeedExcelHelp07	Excel Worksheet Functions	13	October 31st 07 06:43 PM
Automatically filling in a formula in a cell	Don	Excel Discussion (Misc queries)	7	October 22nd 07 09:37 PM
programaticly filling a cell with a formula	[email protected]	Excel Programming	4	January 11th 07 03:45 PM
Error '7' Run out of memory while filling in a cell with a formula	Jim Cone	Excel Programming	2	January 11th 07 03:26 PM
Filling excel entire row/column instead of single cell from an array	shitij	Excel Worksheet Functions	3	July 13th 05 07:44 AM

All times are GMT +1. The time now is 12:30 AM.

Menu

About Us