I need a code that will run a macro on a worksheet that will:
1. add 2 columns to an existing worksheet with matching headers called Program Specialist and Senior Manager
1.jpg
2. Do a vlook-up on the school code based on a separate sheet titled “schools”
2.jpg
3.jpg
3. Place text in the program specialist/senior manager columns in the added columns on the report sheet
4.jpg
4. Filter sheet by senior manager, then create a new sheet and name the tab the name of the senior manager
5.jpg
robinwoodard,
Welcome to the Excel Forum.
You are posting pictures that are extremely small and difficult to read. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.
To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.
The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.
To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
I have added the word document with larger pictures of what I am trying to do. I tried recording the macro, but nothing shows up in the box except what is typed in the initial box where you provide a name and a description.
Here is the workbook that has the information I am working with. Thanks in advance. Is there any place I can reference codes to simple actions in excel, such as inserting page breaks, formatting headers and footers, etc?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks