| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding formulas to cells dependant on data in another cell.
Hello All,
I have a 10 formulas that operate along an Excel row. Initially I had copied the formulas into all rows in a spreadsheet up to row 3000. However this makes my spreadsheet unnecessarily large. What I would therefore like to do is copy the formulas ONLY if data is added into the first column. Is this possible using VBA? For example if I have the formula =A1+B1 operating in cell C1 how could I copy the formula ONLY when data is added to cell s in column ‘A’? Regards, Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells with formulas | Excel Worksheet Functions | |||
| Data in Cell dependant on drop down lists | New Users to Excel | |||
| Adding formulas to cells | Excel Programming | |||
| adding to different totals dependant upon selection from drop down | Excel Worksheet Functions | |||
| Disable a checkbox dependant upon cell data | Excel Discussion (Misc queries) | |||
Threaded Mode
