Beatrix
02-22-2016, 08:51 AM
Hi Everyone
I need to copy/paste values from one tab to another tab based on the number in row 1. The values in Sheet1 are based on a formula but need to be copied into the same column with same assigned number in row1 in Sheet2. However I don't want to copy it with formula, values only.
There would be more than 1000 records so that's why I need to do it with vba. I would really appreciate it if anyone can help me with this please? I attached a sample file.
Thanks very much.
B.
I need to copy/paste values from one tab to another tab based on the number in row 1. The values in Sheet1 are based on a formula but need to be copied into the same column with same assigned number in row1 in Sheet2. However I don't want to copy it with formula, values only.
There would be more than 1000 records so that's why I need to do it with vba. I would really appreciate it if anyone can help me with this please? I attached a sample file.
Thanks very much.
B.