VBA Grab specific cell value from active row

Greetings fellow excel experts,

A very friendly forum expert helped me in the making of the following code;

Please Login or Register  to view this content.

I only need to edit the last part of it though. So what the code does is it grabs the info from X Y and Z cells (figuratively speaking) and puts them all lined up on a row in a separate workbook, there's no spaces between rows. Each row has a number in column B, the code starts pasting info from column C onwards, the small edit I need to figure out is for the code to grab the number in column B of that same row it just added the info, and then take it back to the original workbook where this macro was ran and paste that number on any cell (f.e. W20).

Anyone got any ideas?

Best regards.

Hello,

Yes, that gives me the row where the macro starts adding "varEntries" one by one, but the number is also on a specific column, its in column 2 (B).
My guess is that it should be something along the lines of;

Please Login or Register  to view this content.

But this only for the first varEntry and it would go before this piece of code

Please Login or Register  to view this content.

But then once that part is done, it also needs to come back to the original file where this macro was run and then paste the value on W20.
So this macro is run on, lets say, an invoice template. And when you run it, it registers the invoice in an overview workbook, and when it does so a number is assigned to it. So it needs to take that number from the overview workbook and bring it back.

Best regards.

Nevermind, after further testing the code you provided gets the job done.

Thank you.