Duplicate a column of information in my consolidation code.

[Dremzy]

Hi guys,

I have a piece of code that consolidates data onto one sheet.

Once the code has copied everything over, I would like it to also duplicate the Category field.

Please be advised that there is no option to add the duplicated column in the source information.

Here is the consolidation code:

Please Login or Register  to view this content.

[oeldere]

Make a separated macro for that work and call it in this one.

Maybe you can show us the file, your working on (without confidential information).