| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create an autofill series!
hi all! is there any method to create an autofill series for filling up the following: COL "A" COL "B" 03/01/2006 RECEIPT 03/01/2006 PAYMENT 03/02/2006 RECEIPT 03/02/2006 PAYMENT .. .. .. .. .. .. .. upto .. 03/31/2006 RECEIPT 03/31/2006 PAYMENT -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=522759 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create an autofill series!
I put this in A1:B2
03/01/2006 RECEIPT 03/01/2006 PAYMENT I put these formulas in A3:A4: =A1+1 =A2+1 And I put RECEIPT In B3 and PAYMENT In B4 I selected a3:B4 and dragged it down as far as I needed. (Then I copied|paste special|values) via135 wrote: hi all! is there any method to create an autofill series for filling up the following: COL "A" COL "B" 03/01/2006 RECEIPT 03/01/2006 PAYMENT 03/02/2006 RECEIPT 03/02/2006 PAYMENT . .. . .. . .. . upto .. 03/31/2006 RECEIPT 03/31/2006 PAYMENT -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=522759 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create an autofill series!
thks Dave! your method works perfect!! thks again! -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=522759 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to change ColorIndex for series settings | Charts and Charting in Excel | |||
| Series of web queries: Autofill? | Excel Discussion (Misc queries) | |||
| in excel create series in the presence of [ ] characters | Excel Discussion (Misc queries) | |||
| Can I use AutoFill or a formula to fill a series of letters? | Excel Discussion (Misc queries) | |||
| EXCEL, I want to create a series of calendars with dates marked f. | Excel Discussion (Misc queries) | |||
Hybrid Mode
