davew
10-03-2012, 10:09 AM
Hi, hope one of you guys can help please,
I’m trying to append some values from one table into another table. Normally I’d do this using Index/Match pasted into every cell where I’m trying to append the data to. Due to the larger than normal quantity of data this would mean I’d need a lot of Index/Match calc’s and it gets a bit cumbersome. Is there a workable Index/Match type function in VBA?
I’ve attached a simple example to illustrate what I’m trying to achieve. The first sheet has the data I’m trying to append and the second sheet has the table I’m trying to append it to. If you’re able to structure your response around this then that would be great otherwise any help would be appreciated anyway.
Hope you can help.
Thanks
Davew
I’m trying to append some values from one table into another table. Normally I’d do this using Index/Match pasted into every cell where I’m trying to append the data to. Due to the larger than normal quantity of data this would mean I’d need a lot of Index/Match calc’s and it gets a bit cumbersome. Is there a workable Index/Match type function in VBA?
I’ve attached a simple example to illustrate what I’m trying to achieve. The first sheet has the data I’m trying to append and the second sheet has the table I’m trying to append it to. If you’re able to structure your response around this then that would be great otherwise any help would be appreciated anyway.
Hope you can help.
Thanks
Davew