Fill In across sheets

C

CoachMarty

Can Excel fill in consecutive numbers across sheets? I want the sam
cell in each sheet to increment by 1. I do not want to use VBA (no
advanced enough).

Any help would be appreciated
 
I

icestationzbra

say you have 1 and 2 in cells A1 and A2.

highlight the two. now you should see a black sqaure dot at the righ
bottom of the selection. take the mouse pointer over to the blac
square. the pointer turn to a '+' sign or cross hair. depress the lef
mouse button and drag it down to, say, 10 more rows. you will se
incremental numbers from 1 to 12.

you can do a similar thing along the rows, if you drag right or left
for that you should have atleast 2 numbers along a row for excel t
figure out what it needs to do
 
G

Gord Dibben

Coach

No easy way to do this without VBA but.......

Enter a number in A1 of Sheet1

Switch to Sheet2 A1 and enter =Sheet1!A1+1

Switch to Sheet3 A1 and enter =Sheet2!A1+1

Work your way across incrementing the Sheet name by 1.

If your sheets are not named as such, just substitute them as required.

VBA Code from Auk Ales to do it one whack.

Enter a number in Sheet1 A1(or your choice of cell)then run the macro.
If not using A1, change the code to your cell reference.

Sub Fill_Across_Sheets()
Dim Sh As Worksheet
Dim I As Integer
Dim ShName As String
For I = 2 To Worksheets.Count
ShName = Worksheets(I - 1).Name
Worksheets(I).Range("A1").Formula = "=" & ShName & "!A1+1"
Next
End Sub

Not being familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to Tool>Macro>Macros.

Gord Dibben Excel MVP
 
Top