S
s b via OfficeKB.com
Hi
I have read quite a few posts and still quite new to the whole macro world.
Basically what i am trying to achieve is to be able to insert a column at a
specfic location in a spreadsheet and then cut and paste the data via a macro.
At the moment this is carried out manually were i have to carry out one
function a number of times which can be quite time consuming.
The format is the following:
A B C D E F
1 SubName 2002 2003 2004 2005
2 Sub1 87 89 76
3 Sub2 96 97 98 ==>the
col called 2005 is were this years data will be
4 Sub3 69 70 78
be cut and pasted. Is it possible for this column to
5 Sub4 76 75 76
be inserted and up dated with the data
6 Average 82 89 85
What i am looking to do is develop a macro which will insert a column and
bring 2005 data in, this is carried out yearly. At the moment one workbook
consists of about 5 spreadsheets with about 30 of the above tables so it
would be useful if an automated process could be put in place. Also these
tables have a graph each as well so ideally it wouldbe useful if these could
be updated as well.
I would be grateful for any guidance, thank you for your time
Look forward in hearing from you
I have read quite a few posts and still quite new to the whole macro world.
Basically what i am trying to achieve is to be able to insert a column at a
specfic location in a spreadsheet and then cut and paste the data via a macro.
At the moment this is carried out manually were i have to carry out one
function a number of times which can be quite time consuming.
The format is the following:
A B C D E F
1 SubName 2002 2003 2004 2005
2 Sub1 87 89 76
3 Sub2 96 97 98 ==>the
col called 2005 is were this years data will be
4 Sub3 69 70 78
be cut and pasted. Is it possible for this column to
5 Sub4 76 75 76
be inserted and up dated with the data
6 Average 82 89 85
What i am looking to do is develop a macro which will insert a column and
bring 2005 data in, this is carried out yearly. At the moment one workbook
consists of about 5 spreadsheets with about 30 of the above tables so it
would be useful if an automated process could be put in place. Also these
tables have a graph each as well so ideally it wouldbe useful if these could
be updated as well.
I would be grateful for any guidance, thank you for your time
Look forward in hearing from you