Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy cells into range of cells until cell change
In column C is the name of an employee follwowed by lines of data for
that employee with no further data in column C until the next employee. This sequence repeats itself for 48,000 lines. Is there a formula/macro that will copy the employee name into the next row of column C until the name changes and then repeat for the next name? |
#2
|
|||
|
|||
A brute force macro would be something like
sub nmfill() nm=cells(1,3) for r = 2 to 48000 if cells(r,3)="" then cells(r,3)=nm else nm = cells(r,3) next r end sub "mdeanda" wrote: In column C is the name of an employee follwowed by lines of data for that employee with no further data in column C until the next employee. This sequence repeats itself for 48,000 lines. Is there a formula/macro that will copy the employee name into the next row of column C until the name changes and then repeat for the next name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions | |||
How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
copy paste cell character limit | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |