Copy values from 1 sheet and paste into another while keeping a counter

[JaydenK]

Hello all,

I'm wondering how to copy values of cells in one column and pasting those values into another sheet while keeping a count. I've attached an example of what I'm looking for where the left side is what my file currently looks like, and the right side is what a new sheet would look like. Any help is much appreciated - thanks!

example.xlsx
Sorry, forgot to attach it the first time..

[ragulduy]

No attachment...

[tigeravatar]

JaydenK,

The attachment is missing, so there is currently no example file to look at.
However, here is some generic code (with comments) that will perform as requested and hopefully you can adapt it to your needs:

Please Login or Register  to view this content.

[AB33]

If the numbers in column A are consecutive, this should work.

Please Login or Register  to view this content.

[JaydenK]

tigeravatar, thanks for the code!

A833, if the column I'm collecting numbers from isn't the next one (B in the example), would I be changing this part of the code?

Please Login or Register  to view this content.

Thanks for the help!

[tigeravatar]

JaydenK,

Updated code to work with your sample file:

Please Login or Register  to view this content.

[AB33]

These two lines of the code refer to column B.

Please Login or Register  to view this content.

So, 2, refers to column B. All you have to do is change that number to what ever column B is replaced by for.

[JaydenK]

Thank you tigeravatar and AB33, I tried both codes and they're both great!