Is there a way to insert a row and have the formatting from the previous
row copied?

My other question is how to input data from one sheet and have the rows
insert automatically to another worksheet.

Any help appreciated.


--
victorcab
------------------------------------------------------------------------
victorcab's Profile: http://www.excelforum.com/member.php...o&userid=13675
View this thread: http://www.excelforum.com/showthread...hreadid=400923

The answer to the first question is
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
using the first macro you see there.

The second question is not defined sufficiently.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"victorcab" wrote in message
...

Is there a way to insert a row and have the formatting from the previous
row copied?

My other question is how to input data from one sheet and have the rows
insert automatically to another worksheet.

Any help appreciated.


--
victorcab
------------------------------------------------------------------------
victorcab's Profile: http://www.excelforum.com/member.php...o&userid=13675
View this thread: http://www.excelforum.com/showthread...hreadid=400923