Hello,
thank you very much for your cooperation on your part.
Maybe I wrong somewhere and therefore attach files and pictures to make clear what I mean. I hope you can understand me more clearly what I need, having in mind that this is only an example.
I will try to explain:
I want to just copy Sheet2 and Sheet3.
1 - write all sorts of things, but the most important is the cell C5 - if there is the city of London.
2 - Press the button in Sheet1.
3 - shows a window in which to write my name (title of the new workbook)
4 - automatically finds the folder (in this example "States" - can himself to show the path to it in the macro)
5 - According to the city in cell C5 - opens the folder and there save the new workbook with the name written by me. (in the present case because it keeps on the old document)
Here is link to download samples -> DOX.bg -