Copy+Paste into other workbook

Hello my friends,
I need to copy some cells to other opened workbooks at that moment.

Macro1
Source cell: AL2:AS2 (8 cells) + AL6:AM6 (2 Cells)
Target workbook: Second.xlsx Target sheet: Compare Target cell: L10:U10 (all these 10cells will pasted horizontally together)
I will run macro continously. So macro should check last filled cells in L column. When I run macro first time, paste will be done into L10:U10. Second time when I run it, cells should be pasted into L11:U11
Macro2
Source cell: Y2:AH2 (10 cells)
Target workbook: Third.xlsx Target sheet: Ready Target cell: B2:K2 (10cells)
Each time when I run it, macro firstly should clear contents in target cells (B2:K2), then i should paste them into target cells.

Pls have a check files I attached and you will see how macro should do easily with desired result.
Source file: First.xlsx

Note: Related cells include formula results, so macros should make paste operation as "Special Paste as values".

Related cells are in First.xlsx
So, First.xlsx can be saved as First.xlsm and two macros can be attached to it.
and we can open workbooks: Second.xlsx and Third.xlsx and run the macros.

Manually I'd prefer.

Super
Both two macros work perfectly.

Only I'd like to ask one point for Macro1
I asked to paste AL2:AS2 (8 cells) + AL6:AM6 (2 Cells) into L10:U10 (10 cells together)
If I would ask to paste only AL2:AS2 (8 cells) into L10:S10 (8 cells) , how would you edit the code, sir?

oke sorry
I discovered by myself.
I only omit this part.
Thanks a lor Ross.

Please Login or Register  to view this content.