create new worksheets and populate data
Posted on 2014-04-09
Hi. I have a spreadsheet with 1 worksheet full of customer data: Acct No, name, address, phone, fax, etc and 1 column marked territory (north, south, central, etc...) and 1 column with the regional sales manager initials (manager for account).
Rather than take the time to create a database and move this data in I was wondering if it would be possible to grab the data in worksheet 1 and create and name a worksheet for each of my sales managers. Worksheet1= Customer Listing, new worksheet2 = Manager1, new worksheet3 = Manager2, etc.. along with that I also want to add a heading in row 1 and add soem very basic column formatting to the new worksheet on create. I'm thinking some sort of macro to do all of this but not sure...
Ultimately, I want my managers to go to their section on Worksheet1, find the customer they want to update, click on it (hyperlink to corresponding sheet) and fill in call log data for visits, calls, emails, project updates, etc...) data would be column 1= date and column 2 = call history. Manual entry for each new call logged at that point...