07-01-2005, 05:05 PM
|
|
|
|
Re: Macro for single to multiple cols. Help!
NO. Formulas as in see the formula bar in this pic:
http://www.officearticles.com/excel/images/data_c2.jpg
You DO need to use formulas. You set up the formulas for the first 3 sets of
records. Then you select the cells as shown, and copy down. If you need to,
send the file to anne@ either of the websites below.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"dfkelly42" <dfkelly42.1ri5ye_1120241134.0889@excelforum-nospam.com> wrote
in message news:dfkelly42.1ri5ye_1120241134.0889@excelforum-nospam.com...
>
> Okay, and you "filled the C-F cols" with "[u]*formulas",[/*U] 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.
>
> Formulas? - as in the actual names addresses and states in col C, E &F
> ... YES
> Calculation turned to manual?? Dont understand...
> 1500 records...... i tried it again and am just waiting...
>
>
> --
> dfkelly42
> ------------------------------------------------------------------------
> dfkelly42's Profile:
http://www.excelforum.com/member.php...o&userid=12094
> View this thread: http://www.excelforum.com/showthread...hreadid=383737
>
|