PDA

View Full Version : [SOLVED:] Adjust/Sync Table columns number Base on a Pivot Table Columns Size



smj4444
02-19-2018, 07:35 PM
How can I use VBA to adjust/sync a Table Columns number size base on any of the events of a Pivot Table? I need it to be sync in columns number size with PT. Thanks in advance for the help!

21661

p45cal
02-20-2018, 05:35 AM
Supply or link to a file with such tables.

smj4444
02-20-2018, 05:24 PM
p45Cal, thanks for replying to my post and sorry took this long, uploaded a workbook....

p45cal
02-21-2018, 02:17 PM
Two sheets in the attached, each with its offering.

smj4444
02-21-2018, 07:52 PM
p45cal, thanks for showing the 2 options one of them worked for my need!

p45cal
02-22-2018, 03:05 AM
p45cal, thanks for showing the 2 options one of them worked for my need!As a matter of interest, which one? :yay