knifelong
05-22-2013, 07:41 AM
hi I have a spreadsheet which might have variable headings as below
ID date 2 3 5 8 9
I would like to insert a description in the cell below the numerical value in the heading. The description is derived from a lookup in another workbook or worksheet. there is an example of this below.
1 descriptionA
2 descriptionB
3 descriptionC
4 descriptionD
5 descriptionE
6 descriptionF
7 descriptionG
8 descriptionH
9 descriptionI
10 descriptionJ
so the final result would look like this.
ID date 2 3 5 8 9
descritionB descritionC descritionE descritionH descritionI
I think it will be necessary to do this in VBA but I'm not sure where to start. Any help would be appreciated.
thanks
ID date 2 3 5 8 9
I would like to insert a description in the cell below the numerical value in the heading. The description is derived from a lookup in another workbook or worksheet. there is an example of this below.
1 descriptionA
2 descriptionB
3 descriptionC
4 descriptionD
5 descriptionE
6 descriptionF
7 descriptionG
8 descriptionH
9 descriptionI
10 descriptionJ
so the final result would look like this.
ID date 2 3 5 8 9
descritionB descritionC descritionE descritionH descritionI
I think it will be necessary to do this in VBA but I'm not sure where to start. Any help would be appreciated.
thanks