Hello All,
I may be biting off more than I can chew, but here goes. I have created a user input form in a workbook that contains approximately 50 worksheets, each sheet named after a city. Is there a way to use vba to place the data from the input form in the worksheet that corresponds with the city the user types? The data is formatted exactly the same in every worksheet.
As I have it now, the input data creates a new record in the next available blank row of a summary worksheet. I then have to cut and paste the data into the correct city's worksheet. Tedious!
Thanks in advance for any help!
Bookmarks