How do I insert a row when using an if function

Posts: n/a

How do I insert a row when using an if function

My spreadsheet is a series of dates with related data.
Sometimes there is a date missing in the sequence. I want to add an
additional row in this case and insert zero values for the data.
I would like to do this automatically and am not sure if I can use an if
function to run a macro, ie if to find if a date is missing and if yes,
launch the macro.
Would be grateful for any thoughts on this

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
Challenging Charting	C TO	Charts and Charting in Excel	0	January 17th 05 06:57 PM
Can I change the Insert Function button to an equals sign?	Jokeyjojo	Excel Discussion (Misc queries)	1	January 17th 05 05:45 PM
Insert Function "FX" on Toolbar in Excel	Rich	Excel Discussion (Misc queries)	4	January 16th 05 03:04 PM
Function to automatically insert a new sheet as a result of data entry?	Mark Mulik	Excel Worksheet Functions	2	November 28th 04 02:21 AM
How do I insert a line break when using the CONCATENATE function?	ShaneRuth	Excel Worksheet Functions	2	November 5th 04 11:26 PM

All times are GMT +1. The time now is 03:25 AM.

Menu

About Us