Machsupport Forum

Mach Discussion => General Mach Discussion => Topic started by: BR549 on July 19, 2011, 09:07:23 PM

Title: gCODE /eXCEL SPREADSHEET QUESTION
Post by: BR549 on July 19, 2011, 09:07:23 PM

I have an Excel spreadsheet I am working with and I need to work with 262 cells. I need to start at O and at each cell increase the value by .004267176 up to total number of cells.

 DOES ANYONE have a clue as to how to use a formula to do this?

(;-) TP

Title: Re: gCODE /eXCEL SPREADSHEET QUESTION
Post by: Chaoticone on July 19, 2011, 10:32:37 PM

Terry, will fill series help?

Brett

Title: Re: gCODE /eXCEL SPREADSHEET QUESTION
Post by: Picengraver on July 20, 2011, 05:47:14 AM

Enter 0 in cell A1
Enter =+A1+.004267176 in cell A2

click once on cell A2 to highlight it

Scroll down to cell A261 (262 cells)

hold down SHIFT - click cell A261

hold down CONTROL key - hit D

cell A261 should now read 1.10946576

Hope this is what you need.
John Champlain

Title: Re: gCODE /eXCEL SPREADSHEET QUESTION
Post by: Ya-Nvr-No on July 20, 2011, 06:19:37 AM

Here is a something that might work for you.  
Lets you change either or both numbers to fill your table.

Title: Re: gCODE /eXCEL SPREADSHEET QUESTION
Post by: Ya-Nvr-No on July 20, 2011, 08:16:18 AM

Or you can do it using VBA in excel
gives you even more control
But you have to have macros enabled to use this feature.

Title: Re: gCODE /eXCEL SPREADSHEET QUESTION
Post by: BR549 on July 20, 2011, 02:04:03 PM

AH fill series did the trick. Thanks GUYS

(;-) TP