Hello,
I have a spreadsheet with a userform to manipulate data.
The userform copies in data from Sheet2 into Column J of Sheet3. In Column K I have =J2(Right,10) formula copied down to around row 200,000 - as there are occasions where I may be working with this much data.
A macro copies the data from Column K into Column L, where it is pasted as Values. This is then copied into Column A of Sheet1, where a Macro creates a PivotTable from the data.
However, the main issue I have is that the pivot created looks at a number of blanks, as it will create data from Column A in Sheet1 from A1 down to A200000.
I have tried running code to delete blanks from COlumn A before creating the PivotTable, but it still goes up to A200000.
Any ideas how to get around this?
Kind Regards,
Bookmarks