Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anything that will copy previous entry multiple times?
In other words I have a spreadsheet with 6000 some rows. The 1st column
either has a value or is blank. If it is blank I want it to fill in the one above. I know about some keystrokes but that would take too long. Is there something quicker I could create? Or is there a way to do this in Access? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anything that will copy previous entry multiple times?
Try this short macro:
Sub stacy() n = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To n If IsEmpty(Cells(i, 1)) Then Cells(i, 1).FillDown End If Next End Sub -- Gary''s Student - gsnu200821 "stacey" wrote: In other words I have a spreadsheet with 6000 some rows. The 1st column either has a value or is blank. If it is blank I want it to fill in the one above. I know about some keystrokes but that would take too long. Is there something quicker I could create? Or is there a way to do this in Access? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there anything that will copy previous entry multiple times?
I know about some keystrokes but that would take too long.
Is 30 seconds too long? Select the range in question Hit function key F5 Click: SpecialBlanksOK Type the = sign Press the "up" directional arrow Hold down the CTRL key then hit ENTER The blanks have been filled. With practice this could probably be done in <10 seconds. -- Biff Microsoft Excel MVP "stacey" wrote in message ... In other words I have a spreadsheet with 6000 some rows. The 1st column either has a value or is blank. If it is blank I want it to fill in the one above. I know about some keystrokes but that would take too long. Is there something quicker I could create? Or is there a way to do this in Access? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'move or copy' a single worksheet multiple times | Excel Discussion (Misc queries) | |||
Automatically copy previous cells in data entry in Excel | Excel Discussion (Misc queries) | |||
Copy line multiple times throughout spreadsheet? | Excel Discussion (Misc queries) | |||
macro to copy a value multiple times depending on value in adj | Excel Worksheet Functions | |||
how do i copy the same cell multiple times in excel. | Excel Discussion (Misc queries) |