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

Report

Kyle f - May 12, 2017 at 02:54 PM

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

Create macro on one sheet to update on another sheet
Excel macro compare two sheets and highlight differences ✓ - Forum - Excel
Run macro on active sheet ✓ - Forum - Excel
Create macro outlook - How-To - Office Software
2 macros in one sheet targeting same cells ✓ - Forum - Excel
Please help - run macro when switching sheets ✓ - Forum - Excel

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

Your reply

Subscribe To Our Newsletter!