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???