I want to use values from one spreadsheet into another spradsheet usingVBA. Would anybody tell me how I could write the code for the same.Thanking you all a lot.