copy whole row using a formula
 

Hi there!
I have a s/s with Customer name in Col A and info regarding sales, Budget &
Fcast figures in the next Columns for each month and total per QTR.
This is then grouped in Current, Exiting and At Risk Sub-Headings in the
same s/s(all with total formula's for each column). If a Current customer is
then "At Risk", i would like to be able to go under that sub-heading and
create a reference with "=" and select that row for it to copy and paste into
the new sub-heading but still maintain the info at the original reference,
which isnt that simple : (
I would like to do it as simple as possible, if at all possible? Can anyone
help???

copy whole row using a formula
 

Hi Van,
Take a look at Insert Rows and maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
for you selection you would not be clearing column A.
There are other examples besides the first example.
---
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

"Van" wrote in message ...
Hi there!
I have a s/s with Customer name in Col A and info regarding sales, Budget &
Fcast figures in the next Columns for each month and total per QTR.
This is then grouped in Current, Exiting and At Risk Sub-Headings in the
same s/s(all with total formula's for each column). If a Current customer is
then "At Risk", i would like to be able to go under that sub-heading and
create a reference with "=" and select that row for it to copy and paste into
the new sub-heading but still maintain the info at the original reference,
which isnt that simple : (
I would like to do it as simple as possible, if at all possible? Can anyone
help???