Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill the data
Debra Dalgleish shares some techniques:
http://contextures.com/xlDataEntry02.html http://www.contextures.com/xlVideos01.html#FillBlanks Elton Law wrote: Dear Expert, Got a question. Want to autofill the data from one row to next data row Say for an example, want to fill 13479.35 from 15 Jun to 21 Jun and then stop because it has data in 22 Jun. Then do again, fill new data (13359.69) in 22 Jun till 28 Jun, then stop because it has new data in 29 Jun. Rows separation are uneven because there may have holidays ... So, data may separate by 5 rows, sometimes 3 rows .... I am using Excel 2000. Would be greatly appreciate if you can help. Thanks Befo 15 Jun 13479.35 18 Jun 19 Jun 20 Jun 21 Jun 22 Jun 13359.69 25 Jun 26 Jun 27 Jun 28 Jun 29 Jun 13259.86 2 Jul 3 Jul After: 15 Jun 13479.35 18 Jun 13479.35 19 Jun 13479.35 20 Jun 13479.35 21 Jun 13479.35 22 Jun 13359.69 25 Jun 13359.69 26 Jun 13359.69 27 Jun 13359.69 28 Jun 13359.69 29 Jun 13259.86 2 Jul 13259.86 3 Jul 13259.86 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill data in cell with other existing data. | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Autofill data | New Users to Excel | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
Macro that will autofill a column with data, up to the last row of data in previous c | Excel Programming |