Hi,

Me again, I have a simple problem, but one I cannot work out how to resolve?
I have an excel sheet which is produced as a result of a macro already working?.(it copies and paste values pivot data)
The data looks like the below..(in attached bitmap)

What I need to do sounds easy? I want to move the column "Total Sum of TOTALVAL" to the column left of the one headed "Sum of Qty"?however, depending on what period this is all done, there could be 5 weeks, not the 4 above..which
means I can' t simply tell it to cut column X and paste it into X every time, as each time it might be different?
Any ideas?

PS I also need to get rid of decimal places in any "Qty fields"..again they might change every time depending on 4/5 weeker.