I have to run large reports from a system so I generate the output in csv format. In the past I would run a pivot in excel using SQL to pull in the data from the CSV.
Recently the source system has been upgraded. Since then, if I open the pivot I can see numerical data as...
In my macro, I am copying and pasting a value, this is the code:
If Cells(i, 7).value > 0 Then
With Cells(i, 7).Select
Selection.pastespecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...