Hi,
I want to add a new column in the pivot table which has been system generated. I tried manually to enter a new column, but its not happenning. I attached the sample sheet generated by system. I want to add a New Column in the 1st sheet(Traceability Matrix) after the "Source Requirements" column(Row-8).
Please do let me know if it can be done through Macro.
No it cannot, unless you convert the pivot table to a static range first (which you can also do manually). You can either add the column to the left of the pivot table, or add a new column to the underlying data source.
Hi,
Thanks for your time. I just wanted to know about your comment on " unless you convert the pivot table to a static range first (which you can also do manually). "