Re: Macro for single to multiple cols. Help!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:dfkelly42.1ri5ye_1120241134.0889@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=12094
> View this thread: http://www.excelforum.com/showthread.php?threadid=383737
>


.

Relevant Pages

  • Re: Number 040
    ... ~Anne Troy ... > I want to put the number 040 as a number but it dont allow me. ... > Drazic's Profile: ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: merge fields from excel are formating with too many decimal po
    ... > the value was 7.55 in the formula bar. ... >> Word pulls the VALUE, not the VIEW of the cell. ... >> Anne Troy ...
    (microsoft.public.word.mailmerge.fields)
  • Re: input form and addition
    ... Anne Troy Wrote: ... >> alexanderd's Profile: ... by muliplying the input values of two textboxes togrther to give a sub ...
    (microsoft.public.excel.misc)
  • Re: One More Formula Question
    ... ~Anne Troy ... > I need to get a specific total from the following criteria. ... > doc's Profile: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: email a web page
    ... Anne Troy ... >I am trying to email a web page to a college tutor. ... > but I dont seem to be able to do it. ... Prev by Date: ...
    (microsoft.public.word.pagelayout)