chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
<tbody>
</tbody>
Hoping someone could help with the following. I searched online for a macro (piece together a macro to do the following):
I want to be able to auto fill/fill handle data in Column C, so that C1 copies down to C4, then find the next Cell with data in Col C (C5) and copy down to C7, etc.
I've tried the following:
Dim lRow As Long
lRow = Cells(Rows.Count,1).End(x1up).Row
Range("C:C").autofill destination:=range("C:C" & cells(rows.count,"C").end(xlup).row)
But I don't think I've applied the code correctly.
Would anyone be able to help?
Thank you.
A | B | C | D | |
1 | December 1 | Hot Dog | 2 | |
2 | December 1 | Hot Dog | 3 | |
3 | December 1 | Hot Dog | 4 | |
4 | December 1 | Hot Dog | 6 | |
5 | December 1 | Hamburger | 7 | |
6 | December 1 | Hamburger | 8 | |
7 | December 1 | Hamburger | 1 | |
8 | December 2 | Hot Dog | 5 | |
9 | December 2 | Hot Dog | 7 |
<tbody>
</tbody>
Hoping someone could help with the following. I searched online for a macro (piece together a macro to do the following):
I want to be able to auto fill/fill handle data in Column C, so that C1 copies down to C4, then find the next Cell with data in Col C (C5) and copy down to C7, etc.
I've tried the following:
Dim lRow As Long
lRow = Cells(Rows.Count,1).End(x1up).Row
Range("C:C").autofill destination:=range("C:C" & cells(rows.count,"C").end(xlup).row)
But I don't think I've applied the code correctly.
Would anyone be able to help?
Thank you.