hey guys,
i m a beginner in vba. I m having problem in upgrading my excel vba file.i made a stock data entry file in which
1) i want that my file should create another workbook for each location while adding new location name and ignore if it has already created
2) add data to particular location File say USA data to Usa.xlsx Canada data to canada.xlsx ,the location is choose in combo box.
i successfully managed to transfer my data to a another workbook but i need that it should be filtered and saved in different location file name.
File Attached for your better understand my query.
Bookmarks