I have a worksheet, on which I am using a macro to create a graph. As the data is scattered across various worksheets in the workbook, I am copying the same and creating a continuous set of columns to use for the creation of the graph:
Sheets("Data1").Range("A29:A39").Copy Destination:=Sheets("Chart").Range("AA29:AA39")
Sheets("Data2").Range("D29:D39").Copy Destination:=Sheets("Chart").Range("AB29:AB39")
Sheets("Data3").Range("I29:I39").Copy Destination:=Sheets("Chart").Range("ACI29:AC39")
Sheets("Data3").Range("D129:D139").Copy Destination:=Sheets("Chart").Range("AD29:AD39")
My data looks like this:
CustomerA 489 456 93%
CustomerB 63 0 0%
CustomerC 123 123 100%
CustomerD 185 172 93%
The above are the values I wish to get in the newly copied cells, not how they were calculated using formulas. I am using the above vba for this work.
How can I get the absolute values, instead of the relative formulas in my newly copied worksheet cells?