Hello Guest it is March 28, 2024, 10:41:53 AM

Author Topic: gCODE /eXCEL SPREADSHEET QUESTION  (Read 5084 times)

0 Members and 1 Guest are viewing this topic.

Offline BR549

*
  •  6,965 6,965
    • View Profile
gCODE /eXCEL SPREADSHEET QUESTION
« 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

Offline Chaoticone

*
  • *
  •  5,624 5,624
  • Precision Chaos
    • View Profile
Re: gCODE /eXCEL SPREADSHEET QUESTION
« Reply #1 on: July 19, 2011, 10:32:37 PM »
Terry, will fill series help?

Brett
;D If you could see the things I have in my head, you would be laughing too. ;D

My guard dog is not what you need to worry about!
Re: gCODE /eXCEL SPREADSHEET QUESTION
« Reply #2 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
Re: gCODE /eXCEL SPREADSHEET QUESTION
« Reply #3 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.
« Last Edit: July 20, 2011, 06:30:23 AM by Ya-Nvr-No »
Re: gCODE /eXCEL SPREADSHEET QUESTION
« Reply #4 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.

Offline BR549

*
  •  6,965 6,965
    • View Profile
Re: gCODE /eXCEL SPREADSHEET QUESTION
« Reply #5 on: July 20, 2011, 02:04:03 PM »
AH fill series did the trick. Thanks GUYS

(;-) TP