need copy data to target file

Hi Adriana,

What data you want to copy? and where you want to paste?

Shums  Thanks for you fast response !!

like here

here the destination file
MED_2.xlsx

This question you already asked here and its still opened, where I tried to provided nearest solution.

Sorry further I cannot find a solution.

well the question that is open don't have this file
but i let it open because this

So i let some time  

but the file heres is not the same as that question

OK.

No problem. Let Subodh handle this question as well. Its almost same problem different files.

In the P2 sheet, I don't understand why cell G22 is 4 since in the wktaSSS_v2--1-.xlsm workbook there are no 83 in column CF.

Martin Liss  Welcome Back  Very Glad to see you !! Good  Friend of Mine

There are no yellow cells in 21W2017. Should anything from that week show up on P2?

Martin Liss  Welcome Back  Very Glad to see you !! Good  Friend of Mine

Me too :) Thanks Martin Sir to pop in :)

Would it be OK if the sheet looked like this?

Martin Liss  the taget file don't have all dates in

as i just try  to make an sample data for easy work

but i will  put as needed  back and foward the date  when working on

the date in target file is column down   in source file is in row

Martin
Would it be OK if the sheet looked like this?

No.the correct format is     1w 2w  allw     in same row after the date in target file

How about this?

Martin Liss

Yes !!

you always surprise me !  Great JOb !

Martin  can be column with the color  too ??

Does the P2 sheet need to be in its own workbook, or can it be added to wktaSSS_v2--1-.xlsm?

Martin
Does the P2 sheet need to be in its own workbook, or can it be added to wktaSSS_v2--1-.xlsm?

need be on its own workbook

Martin  can be column with the color  too ??

Do you mean AE, AH, etc? If so, yes.

Martin
Do you mean AE, AH, etc? If so, yes.


yes that will help me alot

Martin  Great Job like always !!

You Lead The Way  Martin Liss

Very very impressive!! Great JOB