pcarmour
09-26-2013, 08:46 AM
Hi,
After inserting a column which may be anywhere on a worksheet I want to copy the new column with its heading and insert it in exactly the same position on two other worksheets. For example I will insert a column 'H' and give it the heading LONDON I then want to copy this column and insert it as column 'H' on two other worksheets (Called Placing_Record and Year_Summary), whichever column I originally insert I want to repeat but it will not always be 'H'
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
After inserting a column which may be anywhere on a worksheet I want to copy the new column with its heading and insert it in exactly the same position on two other worksheets. For example I will insert a column 'H' and give it the heading LONDON I then want to copy this column and insert it as column 'H' on two other worksheets (Called Placing_Record and Year_Summary), whichever column I originally insert I want to repeat but it will not always be 'H'
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)