excel auto fill

I have a excel sheet with a series of random numbers, for each cell in this series I need it to create a series of numbers in a second sheet based on a single cell in the series in the first sheet. For example if a cell in first sheet is 144;I would like to create 144 new rows on second sheet...

How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....

Hi, I am trying to make one column(A1). Row 1 to 15 should contain ones, row 16 to 30 two's etc.. Below the examples of my errors (I tried with three numbers but I actually need 15). When I first drag the bottom right corner I get 2,4 instead of 3. When I change the properties of the cells to...

Hi, I need help as follows: I have a Summary Sheet to display fixed data from adjacent sheets with same cell location i.e A8. Each sheet name represents day of month (1, 2, 3---31) Each sheet (Day) has data in Cell A8 that I need to display on the Summary sheet (='1'!$A$8) but now I would like...

Here is my problem.. I have 2 sheets.. 1st sheet looks as.. Locale OS Version Size US win7 10 30 US mac 10.7 10.1.4 45 ***an win7 10 78 ***an mac 10.7 10.1.4 90 ***an...

how can i auto fill a range while leaving the cell number the same? =IF(AND(B4>=c2,b4<=c3),"Yes","No") the horizontal cells(ie. a4,c5,c6,c7,c8,c9), with the formula,cells c2 and c3 will remain the same C4=IF(AND(B4>=c2,b4<=c3),"Yes","No") C5=IF(AND(B5>=c2,b5<=c3),"Yes","No")...

I want my seq_no column (B) to auto fill by 10s but I need it restart the series when the number in column A changes. <tbody> item_no seq_no 710000 10 710000 20 710001 10 710001 20 710001 30 710001 40 710002 10 710002 20 710002 30 710003 10 710003 20...