I need to multiply a complete column of data. I don't need to keep to
original data only the results. I've been using a new column and then cutting
and pasting the data back to it's original position. Is there a method of
doing this that will just overwrite the original data without the need for
all the cutting and pasting?
Many Thanks
Hi,
Put the multiplier in a call and copy it.
Select the colmn to multiply and then
Edit|Paste Special
Select Multiply and click OK
Delete the multiplier.
Mike
> I need to multiply a complete column of data. I don't need to keep to
> original data only the results. I've been using a new column and then cutting
[quoted text clipped - 3 lines]
>
> Many Thanks
barney633 - 16 Mar 2008 12:21 GMT
Many thanks, easy when you know how!
Thanks again.
> Hi,
>
[quoted text clipped - 13 lines]
> >
> > Many Thanks