Results 1 to 24 of 24

VBA - combining cell according to the my condition.

Threaded View

  1. #1
    Registered User
    Join Date
    01-01-2015
    Location
    united kingdom
    MS-Off Ver
    2003
    Posts
    17

    VBA - combining cell according to the my condition.

    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.
    Attached Files Attached Files
    Last edited by Nirupay Robi; 01-04-2015 at 01:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining two separate if statements depending on a condition
    By rundrm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2013, 12:34 AM
  2. Macro for combining multiple sheets to one sheet with a condition
    By ashaanna88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2013, 05:18 AM
  3. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  4. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 PM
  5. Combining data in several rows if a condition is met.
    By kingcal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2011, 05:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1