Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filling up data in blankrows!
hi! i am having dates in A1,A4,A7,A10. i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so on! is there any formula for filling up data in the above manner? hlp pl? -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=503029 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filling up data in blankrows!
Hi
Use this http://www.contextures.com/xlDataEntry02.html -- Regards Ron de Bruin http://www.rondebruin.nl "via135" wrote in message ... hi! i am having dates in A1,A4,A7,A10. i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so on! is there any formula for filling up data in the above manner? hlp pl? -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=503029 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filling up data in blankrows!
Debra Dalgleish has a manual method (quicker) and code at:
http://contextures.com/xlDataEntry02.html via135 wrote: hi! i am having dates in A1,A4,A7,A10. i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so on! is there any formula for filling up data in the above manner? hlp pl? -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=503029 -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filling up data in blankrows!
Select column A and F5SpecialBlanksOK
Now in the active blank cell type an = sign. Point to the cell above and CTRL + ENTER to fill down. You can then copy and paste special(in place)valuesokesc to get rid of the formulas. Gord Dibben MS Excel MVP On Thu, 19 Jan 2006 13:21:47 -0600, via135 wrote: hi! i am having dates in A1,A4,A7,A10. i want to fill up A2 & A3 with date in A1, A5 & A6 with date in A4...so on! is there any formula for filling up data in the above manner? hlp pl? -via135 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filling up data in blankrows!
thks..RON, DAVE & GORD! its really quite useful for me! -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=503029 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
In a column with no data, only color filling, how can I filter fo. | Excel Discussion (Misc queries) |