Can anyone Please look at my attach file. I need this.
1) Take all the timeblocks and put them in an array. Place across Row 1 starting at column B.
2) Take first petsitter (column E ) find all Morning visits and put them in the format Client (in capital) next line Service (without Parenthesis) next line Parenthisis Total Price (column L with only the dollar amount) / then Total ( column O with only dollar amount) closed Parenthisis. Each appointment should be seperated by a line.
3) Place those walks under the morning column in the correct Petsitter row.
4) Do instructions 2 & 3 for the rest of the Timeblocks.
5) Go to the next Pet Sitter and do the same thing until all the walkers are done.
6) Alternate rows with white and gray background.
7) Make the Rows with the Headers for Timeblocks blue.
8) Center everything
Please look at summury sheet. I have done some row.
Bookmarks