Copy Data from one workbook to other by transpose

[ExcelSeeker007]

Hi Friends,

I have a VBA automation to be completed as part of my work. I have to copy data from workbook1 to workbook2 (different workbooks), but the challenge is data needs to be transposed based on criteria, simple transpose is not working as need to check some conditions.Region1,Region2.....will vary so need to paste dynamically.

I am attaching file with structure.

Any help will save me a lot, Thanks in advance for help.

Workbook1:

Workbook2:

 

[vladimiratanasiu]

Hi Friends,

I have a VBA automation to be completed as part of my work. I have to copy data from workbook1 to workbook2 (different workbooks), but the challenge is data needs to be transposed based on criteria, simple transpose is not working as need to check some conditions.Region1,Region2.....will vary so need to paste dynamically.

I am attaching file with structure.

Any help will save me a lot, Thanks in advance for help.

Workbook1:
View attachment 43197

Workbook2:
View attachment 43198

What are the specific criteria / conditions?