Hi,

Need a help!!

I have below mentioned formula:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+J
'
Cells.Select
Range("C12").Activate
Sheets(Array("Start", "PO", "NMPF", "FinalApprovalSheet", "Payment
Request", "GRN", _
"Sig_Masters", "Vendor_Master", "ITEM_MASTER", "Masters",
"Address_Master", _
"Sig_Auth")).Select
Sheets("Start").Activate
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("E16").Select
Sheets("Start").Select
Range("C14").Select
End Sub

As soon as I run this macro Paste Value options starts.

The only issue is it runs on the single file.

I have aprox 100 similar Files. I want a macro which ask me to select
multiple files and then run a macro to save time.

Pls help me to close this.

Thanks in Advance

Rgds

Akash Maheshwari