processed

​Hi, what do I need to add to the below code to only count the visible data after filtering. I assume it is possibly .SpecialCells(xlCellTypeVisible) or similar after With Worksheet("calculations"), but I can't figure it out. Help appreciated. Sub Count_only_visible_data()With ActiveSheet...

Hi All, I would like to run the below code four times with four different date ranges, 1. This month, 2. Last month, 3. Last quarter, 4. Previous quarter (the quarter prior to last quarter). I would like them NOT static, but rolling forward with time if possible, cheers. Private Sub...

Hi, I have two arrays that contain a date, amount and description. I need to compare the two arrays and then process the differences. Possibly place the contents in another array so they can be processed or output them into a sheet. Thanks

So Column A is a month (January), column B is the date an order was received, and column C is the date the order was processed. I'm trying to count how many times in the month of January the order was processed after the day it was received. I keep getting referred to SUMPRDUCT but that's not...

Hi All! My question is that I have numerous workbooks that an employee keeps record of and keeps data in Cell P1. (Different workbook for every day). I need to retrieve Cell P1 to compile the information into one ongoing running sheet. Example below: Shift 1 Dept A in its own workbook...

Hi Folks, Col K is populated by formula = $A1&$B1,$C1,$D1,$E1 and may be txt or numeric as processed internally elsewhere. Col N is populated manually, txt or numeric Col M =IF(AND($K1="",$N1=""),"",IF($K1<>$N1,"Error","OK")) The object is to determine whether a manual entry is same as...

hi Guys, I need a help in finding Weighted Average in excel. Attached is the Excel data. Resource Client A Client B Client C Client D Client E Client F Client G Tgt 80 8 80 8 150 8 150 8 150 8 150 8 150 8 A 0 0...

Hi, I am trying to speed up a process I currently do, I get sent an email everyday of goods which have been processed. However I want to create a macro that carries out a few transactions for me in one go to save some time. I get an email like below: 3-PPP-00016-GH1-50% 14-PPP-00017-GH1-50%...

Is it possible to incorporate multivalue fields in a 'make table' query? Essentially, I have a list of clients that are processed in various months. The months they are processed to not always follow a pattern. So, I stored the months they are processed are in a single multivalue cell in Table...

Hi Everyone, For our orders there is a large comments field, somewhere in there always the standard text of the date, the person's initials and "PROCESSED ORDER" to signify they processed the order (e.g. "08/14/2017 EAS - PROCESSED ORDER"). There is often un-needed text before and after this so...