Hello, I am totaly new to VBA and I'm trying to modify a macro that was given to me but it doesn't seem to be working. I'm trying to extract data from three excel spreadsheets, put it into a combined one which creates a pivot table and sorts it into different fromats. Here is the code, can any body help?
[CODE=vb]Sub Update_Land_Act uals()
On Error Resume Next
If InputBox("Enter password to continue", "Centex...