Hi All,
Regretably ( or embarassingly ) I am not even sure where to start with this challenge - normally I can edit a bit (lot) of code and get something working.
INPUT - My challenge is I have approximately 26 columns of data in a long list with headings and a field call Account Exec. some of these values are also numeric - a Client Income Report.
OUTPUT - What I am looking to do is take the aforementioned data 1. Create a New Sheet for Each Person in the List 2. Copy the headings into Row 1 from original sheet 3. Copy data only for that person to that sheet 4. In Row 3 put in a down total.
I have attached a sample to hopefully show better how this should look.
Happy to expand further if anyone has a follow-up.
Thanks in advance.
Rob
Bookmarks