Hi Everyone,
I have a problem today. When I create a Pivot Table based on all columns from the source sheet, where I use macro's to collect data, it does not contain all the values from the source.
I have a worksheet named: DATA. It contains data gained in two ways:
a) column A copied from OTIF-sheet to DATA-sheet --> macro module,
b) columns B:AC calculated data by a worksheet macro.
Do you know what the problem is and how could I solve it? I assume that the macros have impact on this matter.
Any feedback is really appreciated.
I have a problem today. When I create a Pivot Table based on all columns from the source sheet, where I use macro's to collect data, it does not contain all the values from the source.
I have a worksheet named: DATA. It contains data gained in two ways:
a) column A copied from OTIF-sheet to DATA-sheet --> macro module,
b) columns B:AC calculated data by a worksheet macro.
Do you know what the problem is and how could I solve it? I assume that the macros have impact on this matter.
Any feedback is really appreciated.