Automatically copying a row containing formula

=?Utf-8?B?UHJpeWE=?=

Guest

Posts: n/a

24th Nov 2006

Hi
I have developed a worksheet with lot of formulas in it. I want to provide
at lease 6000 Rows to update. If I write formula in every cell it consumes
memory.
Can I have a way to copy the formula on Next 10 row automatically when I
finish adding a record.
I also don't want user to press any button for macro. It should be done
automatically without users knowledge.

Can somebody suggest.....??

« Converting string "061123" into a date "23/11/06" | Refreshing a combo box...? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying formula with worksheet name-need new formula to have anotherworksheet name	Kim	Microsoft Excel Discussion	1	4th Feb 2010 06:44 PM
Automatically change ranges when copying formula	Mally	Microsoft Excel Misc	7	23rd Apr 2009 03:32 PM
copy formula result (text) only - without copying formula	Mulberry	Microsoft Excel Misc	2	2nd Oct 2008 09:51 AM
copying the Hyperlink function result without copying the actual formula	mcheng	Microsoft Excel Worksheet Functions	2	9th Jun 2007 02:43 AM
Copying formula with cell reference decreasing automatically	mworth01	Microsoft Excel Misc	8	21st Apr 2006 08:59 PM