Sorting after copying

[Steve Scully]

My problem is this:

I have a series of tables that I update regularly. The total of each table
is then copied to a list. For example if the total is in cell G9 then the
list entry is =G9. The problem is when I sort the list, the numbers bear no
resemblance to the original values. Is there a way to keep the numbers from
changing while I sort?

 

[GS]

My problem is this:

I have a series of tables that I update regularly. The total of each
table is then copied to a list. For example if the total is in cell
G9 then the list entry is =G9. The problem is when I sort the list,
the numbers bear no resemblance to the original values. Is there a
way to keep the numbers from changing while I sort?

The problem is that your formula uses relative refs. This is subject to
being based on where the cell with the formula is located relative to
the cell being referenced in its formula.

Use absolute refs instead...

=$G$9

...so relocating (ie: sorting!) persists an absolute ref to G9!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Steve Scully]

The problem is that your formula uses relative refs. This is subject to
being based on where the cell with the formula is located relative to the
cell being referenced in its formula.

Use absolute refs instead...

=$G$9

..so relocating (ie: sorting!) persists an absolute ref to G9!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thanks.