streamline

I have several worksheets in the same Excel file where I need to clear the contents in these specific columns (A,D,G,J,M,P,S & V) starting at row 2 in each column. My worksheets are named (8am, 12pm, 2pm, 4pm and 6pm) - Here is the code so far that clears these contents but it seems like I...

I have a Spreadsheet with over one-million rows of data. Of course it takes awhile to load or even update. Plus when I try to run a filter it vegetates every time. I was wondering if there are things I can do (e.g. save in older formats, remove "bells and whistles" or formatting) that would...

Hi all, I have the following formula working but it looks a bit cumbersome - is there a way to streamline it? =SUM(SUMPRODUCT(SUBTOTAL(9,OFFSET(Timekeeping[Units / Hours],ROW(Timekeeping[Units / Hours])-MIN(ROW(Timekeeping[Units / Hours])),0,1))*(Timekeeping[Date] >...

Hi All, I originally posted a question here about Syllogisms (If A = B and B = C then A = C). Here is the Spreadsheet I need help with. !Please note that to reduce calculation time, I’ve removed all but a text version of most of the formulas, which can be found at the top of their respective...

Hi All, Currently I have some code that looks like this: Range("A1:A30") = Workbooks(newbooks).Sheets(1).Range("A1:A30").Value Range("C1:C30") = Workbooks(newbooks).Sheets(1).Range("C1:C30").Value Range("E1:E30") = Workbooks(newbooks).Sheets(1).Range("E1:E30").Value This works fine however I...