Welcome, Guest. Please login or register.
Did you miss your activation email?
May 28, 2012, 01:59:11 AM

Login with username, password and session length
Search:     Advanced search
* Home Help Search Calendar Links Login Register
+  Machsupport Forum
|-+  Mach Discussion
| |-+  General Mach Discussion
| | |-+  gCODE /eXCEL SPREADSHEET QUESTION
Pages: 1   Go Down
Print
Author Topic: gCODE /eXCEL SPREADSHEET QUESTION  (Read 334 times)
0 Members and 2 Guests are viewing this topic.
BR549
Active Member

Offline Offline

Posts: 2,557


View Profile
« on: July 19, 2011, 08: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
Logged
Chaoticone
South Carolina, US
Administrator
*
Offline Offline

Posts: 3,598


Precision Chaos



View Profile WWW
« Reply #1 on: July 19, 2011, 09:32:37 PM »

Terry, will fill series help?

Brett
Logged

Grin If you could see the things I have in my head, you would be laughing too. Grin
www.precisionchaos1.com
My guard dog is not what you need to worry about!
Picengraver
Active Member

Offline Offline

Posts: 82


View Profile
« Reply #2 on: July 20, 2011, 04: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
Logged

Ya-Nvr-No
Active Member

Offline Offline

Posts: 268


Scuptris 3D


View Profile
« Reply #3 on: July 20, 2011, 05:19:37 AM »


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

* br549-excel.xls (26 KB - downloaded 20 times.)
« Last Edit: July 20, 2011, 05:30:23 AM by Ya-Nvr-No » Logged
Ya-Nvr-No
Active Member

Offline Offline

Posts: 268


Scuptris 3D


View Profile
« Reply #4 on: July 20, 2011, 07: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.

* br549-excel-2.xls (98.5 KB - downloaded 17 times.)
Logged
BR549
Active Member

Offline Offline

Posts: 2,557


View Profile
« Reply #5 on: July 20, 2011, 01:04:03 PM »

AH fill series did the trick. Thanks GUYS

(;-) TP
Logged
Pages: 1   Go Up
Print
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!