With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, November 28, 2012
yogi_Extract Sales Records In Sheet 'Each1' From Sheet 'Each' by Specific Dates But Exclude Canceled Sales Logged In Sheet 'CXL'
Actually that's a small bit of sanitized sample data.
So info about each order is entered into the first sheet, named "each"
the sheet "dates" has periods of time, which are pulled into QUERY statements in cell A1 on the numbered sheets:
"each1" "each2" "each3" "each4" respectively.
Other stuff happens from there, I left a few sheets but they aren't important. What I'd like to happen is for the four numbered "each" sheets to pull rows from the main "each" sheet within the date frame (works already) but also where the order# in column B does not match any order number in column A of the sheet named "cxl"
"cxl sheet would be a maintained list of orders that were cancelled for some reason, and I don't want them included in any further calculations in this part of the operation.