-
You could create a named range on your data and then just refer to this named range for your new pivot table. You will still need to specify which fields are your rows and columns. Otherwise another shortcut is just to copy your pivot table and paste it to a new destination, it will then have the same combination for columns and rows.
-
Hi, the easiest way (avoiding vba programming) would be to use the font marlett, where "b" is a tick and "r" is a cross. You can then just use a countif formulae: =countif(A:A,"b") Column A b 3 r b r b
-
Hi J, Just select all your data, push Ctrl+F (and use the replace function) Find 0 and replace with (just leave blank. Nice quick solution! Warren
-
Hi Rollins, this code does the applied changes on the current selection. As you can see you can use the borders collection or the borderaround method, either does the trick Private Sub CmdClearBorder_Click() With Selection .Borders(xlDiagonalDown).LineStyle = xlNone .Borders(xlDiagonalUp).LineStyle = xlNone .Borders(xlEdgeLeft).LineStyle = xlNone .Borders
-
Thanks Bob Nice one! Thought I was going mad! Lesson learnt! Warren
-
Thanks Bob, I have done this, this is why I'm getting so frustrated, it should work. Sub EmailInvoices() Dim XCount As Integer Dim XEmail, XSubject, XBody As String Dim XAttachement As String 'find the last row of data Sheets("Control").Select Range("B11").End(xlDown).Select XLastRow = Selection.Row 'loop through list
-
I have an excel list of emails that I want to loop through and send via a vba function. FullName Email Attachment Ann Hinde name@telkomsa.net C:\Users\Warren\Documents\Warren\NorthernPostal\Reciepts\PS001.pdf Warren Hinde email@hotmail.com C:\Users\Warren\Documents\Warren\NorthernPostal\Reciepts\PS002.pdf The EMail function is as follows: Function RDB_Mail_PDF_Outlook