I have currently created a Macro which runs through each cell in a column, opens the file that the cell refers to and takes data from the file and pastes it some where else. However, there are some errors because all files are not standardized. I know that it is possible to create an error message in case there is an issue. However, is it possible for me to allow whoever runs the macro to manually intervene and change the data that has been pasted and then allow the macro to continue from where it stopped?
Hope I was able to explain my problem well, if not feel free to ask. Appreciate any help
