Paste Special

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a row of values that I need to past diagonally to another workbook

IE Copy B7:B11 paste value to B7 D6 F5 H4 J3 and L2

I would record a macro, but my source file, destination file and destination cells change from month to month. Any suggestions?
 
Hi
is there any logic behind which target cells and target worksheet
you're trying to use from month to month (e.g. inclueded the month name
in the worksheet name, etc.)
 
Yes. The source file would change from GABT0401 to GABT0402 (the source cells don't change). The destination file would change from GLP0401 to GLP0402.

In GLP0401 I would be pasting into cells B7, C6, D5, E4, F3 etc. In GLP0402 I would paste into cells B8, C7, D6, E5, F4 etc.
 
Back
Top