Create macro on one sheet to update on another sheet [Closed]

Report
-
Hello,

Trying to create a macro that will update data onto another sheet. Further this other sheet will be spending on the file path that the user selects, such as their city. Example would be the Hartford buyer will input Hartford into a cell, the macro will find the shared folder Hartford.xlsm and it will imprint the correct information for me. Each day the buyer will hit the send button and it will send me the correct information. So I'm looking to create a macro that will allow a user to type in their city, type in the date and then save information onto a separate sheet in the appopriate spots. There are 6 items that I would want saved

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!