Jeffreyxx01
Board Regular
- Joined
- Oct 23, 2017
- Messages
- 156
Hi guys,
I have something to work on and I dont know how to start on it,
I have hard coded data from A to J and I have created formula from K to V,
I have the unique code in column F, looks like this:
<colgroup><col></colgroup><tbody>
</tbody>I want to be able to find the next unique code in column F, copy and paste the row K2:V2 at each new unique code,
Also I want to be able to create automatic sum of the column K at the end of the last unique code, so I want to sum the column J from first code ABI001 until the last one,
If anyone has an idea or need more explanation I can try explaining more.
Thanks a lot
I have something to work on and I dont know how to start on it,
I have hard coded data from A to J and I have created formula from K to V,
I have the unique code in column F, looks like this:
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ABI001 |
ADA002 |
ADA002 |
ADA002 |
ADA002 |
ADA002 |
ADA002 |
<colgroup><col></colgroup><tbody>
</tbody>
Also I want to be able to create automatic sum of the column K at the end of the last unique code, so I want to sum the column J from first code ABI001 until the last one,
If anyone has an idea or need more explanation I can try explaining more.
Thanks a lot