smillshome
New Member
- Joined
- Jun 16, 2009
- Messages
- 2
Good afternoon all,
I would be grateful if someone could help me with this problem:
I have 2 sheets, Sheet1 has a list in column A of cost centre numbers:
A
250
500
1201
1202
1203
Sheet2 has the merged cells for this list starting with column C
A B C:D E:F G:H etc
How can I get the list from Sheet1 to populate the merged cells in Sheet2
The list on Sheet1 will change in length over time as we add more cost centres to it.
I found a snippet of code elsewhere but was unable to get it to work with the merged cells.
Any help would be appreciated.
Thank you.
I would be grateful if someone could help me with this problem:
I have 2 sheets, Sheet1 has a list in column A of cost centre numbers:
A
250
500
1201
1202
1203
Sheet2 has the merged cells for this list starting with column C
A B C:D E:F G:H etc
How can I get the list from Sheet1 to populate the merged cells in Sheet2
The list on Sheet1 will change in length over time as we add more cost centres to it.
I found a snippet of code elsewhere but was unable to get it to work with the merged cells.
Any help would be appreciated.
Thank you.