Closed Thread
Results 1 to 6 of 6

How do I make a Daily list of orders into one weekly list with no rows empty

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 20010
    Posts
    3

    Post How do I make a Daily list of orders into one weekly list with no rows empty

    Hi, I have daily lists of orders in the same workbook. Mon-Sat. How do I bring all these together into one list and can this list be done dynamically as each daily list is completed?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: How do I make a Daily list of orders into one weekly list with no rows empty

    Hi Jaycceeistheman,

    Welcome to the forum

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: How do I make a Daily list of orders into one weekly list with no rows empty

    The cash sheet work book is attached.

    I have shown one patient on each day. This is sorted and filtered into orders on the same page. I need each daily ordered to be combined into one sheet, ORDER worksheet.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-07-2014
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 20010
    Posts
    3

    Re: How do I make a Daily list of orders into one weekly list with no rows empty

    Hi
    You will see the cash sheet work book attached.

    Each day has one order, this is sorted into the daily orders on the same sheet. I then want to bring all the daily order through to the weekly summary on the WEEKLY ORDER sheet.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-07-2014
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 20010
    Posts
    3

    Re: How do I make a Daily list of orders into one weekly list with no rows empty

    Meant to upload this examply file???!!!?? Sorry.
    Attached Files Attached Files

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How do I make a Daily list of orders into one weekly list with no rows empty

    Thread posted in Commercial services, hence closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-22-2015, 11:40 AM
  2. [SOLVED] extract only certain values from a list which contains empty rows
    By Teaorchid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-19-2013, 06:13 PM
  3. Replies: 0
    Last Post: 12-18-2012, 05:40 AM
  4. list box-hide empty rows
    By sunilmulay in forum Excel General
    Replies: 5
    Last Post: 08-29-2012, 11:30 AM
  5. [SOLVED] remove all the empty rows at the end of my list?
    By rantz in forum Excel General
    Replies: 2
    Last Post: 02-07-2006, 07:00 PM

Tags for this Thread

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