Search results

I have had to copy a column of dates to a new column to extract the month and be able to make subtotals based on each month. Now I am trying to tidy up the column by removing all the cells containing the month and leave behind the subtotals. I have got a little way there using: lastrow2 =...

Hi, I have created some subtotals in some columns of data which for example are the dates, names, and amounts of invoices. The code I used is: Range(Range("C1"), Range("C1").End(xlDown)).Select Selection.CurrentRegion.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3) This is working...

Hi, I am trying to simply find the sum of a range of data...I have tried putting the range into a the formula, and also creating aliases for the cells but it either doesn't work or I keep getting a name error in excel and I just can't seem to hit the nail on the head with right code: The range...

Hi, I am trying to export and then format a series of queries into worksheets in excel. I have managed so far to get this to work and I have managed to achieve some formatting but I don't really understand why it is doing what it is doing and some things that I think should work, don't!! Here...