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: ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ABI001 ADA002 ADA002 ADA002 ADA002 ADA002 ADA002 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Find next unique value and copy and paste certain array at first row of the unique code

Thread starter Jeffreyxx01
Start date Feb 28, 2018
Tags

abi001 ada002 code column unique

Jeffreyxx01

Board Regular

Feb 28, 2018

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:

ABI001

ADA002

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