Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Sheets("Procurement Plan Master").Select
  2. Sheets("Procurement Plan Master").Copy After:=Sheets(6)
  3. Sheets("Procurement Evaluation Tool").Select
  4. Range("L9").Select
  5. Selection.Copy
  6. Sheets("Procurement Plan Master (2)").Select
  7. Range("O18").Select
  8. ActiveSheet.Paste Link:=True
  9. Sheets("Procurement Evaluation Tool").Select
  10. Range("M9").Select
  11. Application.CutCopyMode = False
  12. Selection.Copy
  13. Sheets("Procurement Plan Master (2)").Select
  14. Range("P18").Select
  15. ActiveSheet.Paste Link:=True
  16. Sheets("Procurement Evaluation Tool").Select
  17. Range("N9").Select
  18. Application.CutCopyMode = False
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement