Hi,
I am struggling with getting code for the following. In short I would like to use HLOOKUP to find a value in Sheet 2 and then copy and paste all the data below into Sheet 1.
So simple example
Sheet 2 (Upper left cell is A1):
<tbody>
</tbody>
Sheet 1 (assume upper left is A1 and B1 is the input variable.
<tbody>
</tbody>
The issue I am having is that I struggle how to cope with the different amount of rows that I need to copy.
Any help would be greatly appreciated.
Thanks!
I am struggling with getting code for the following. In short I would like to use HLOOKUP to find a value in Sheet 2 and then copy and paste all the data below into Sheet 1.
So simple example
Sheet 2 (Upper left cell is A1):
Jan | Feb | Mar | Apr |
44 | 6 | 7 | 10 |
21 | 17 | 35 | 1 |
3 | 19 | 31 | 17 |
45 | 1 | 12 | |
15 | 11 | ||
46 | |||
|
<tbody>
</tbody>
Sheet 1 (assume upper left is A1 and B1 is the input variable.
Month | Feb |
<tbody>
</tbody>
The issue I am having is that I struggle how to cope with the different amount of rows that I need to copy.
Any help would be greatly appreciated.
Thanks!