07-01-2005, 12:05 PM
|
|
|
|
Re: Macro for single to multiple cols. Help!
Okay, and you "filled the C-F cols" with formulas, right? And you don't have
your calculation turned to Manual, do you? When you do this with a large
file, it takes a while for all the addresses (formulas) to update. I did it
with 4000 records (12,000 rows), and it took a while for all the
calculations to update. Before it updates, it just looks like I copied the
first ones.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"dfkelly42" <dfkelly42.1rhxmo_1120230425.1544@excelforum-nospam.com> wrote
in message news:dfkelly42.1rhxmo_1120230425.1544@excelforum-nospam.com...
>
> Anne, I went to the site and it seems to be what Im after, but the
> instructions are just out of reach....
> Any words of advice,
> I cant get the copy to fill the series........
> I filled the C-F cols just like the picture, 3 sets of the first three
> names and addresses.
> highlighted the new group, like displayed, right clicked the bottom
> right corner and dragged to the bottom off the page.
>
> Just get copies of the highlighted area...
> where am I going wrong?
>
> Don
>
>
> --
> dfkelly42
> ------------------------------------------------------------------------
> dfkelly42's Profile:
http://www.excelforum.com/member.php...o&userid=12094
> View this thread: http://www.excelforum.com/showthread...hreadid=383737
>
|