Copypaste special (values only) from one workbook to another

[steve2115]

Excel Genius's. Need some help with vb code to copy and paste special (values only) from one workbook to another.

Workbook locations are on my desktop for now, however I plan on filing them on server drive later.

Here is what I need to accomplish:

Copy cell values (D4, D6, J4, L4, L6, & range D12:L19) from Expedite Requisition Request Form.xlsm and Paste special (values only) to Expedited Requisition Request Summary.xlsx file once Expedite Requisition Request Form.xlsm file is submitted. I currently have macro for users to Submit the request. As additional requests are submitted data should paste one row below and so forth.



Expedite Requisition Request Form.xlsm Sheet1 D4 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 A2
Expedite Requisition Request Form.xlsm Sheet1 D6 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 B2
Expedite Requisition Request Form.xlsm Sheet1 J4 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 D2
Expedite Requisition Request Form.xlsm Sheet1 L4 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 E2
Expedite Requisition Request Form.xlsm Sheet1 L6 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 C2
Expedite Requisition Request Form.xlsm Sheet1 D12:L19 PASTE VALUES ONLY TO Expedited Requisition Request Summary.xlsx Sheet1 F2:M2

Thanks!

 

[mole999]

maybe try this Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros

 

[steve2115]

Unfortunately I don't think that will work in this situation. Thanks