Excel Macro Help [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I was wondering if it were possible to have a macro that would work for different sheets for having the column be pasted as long as the name matched with the same column in the first sheet.

ex.
I have 1 column in sheet one saying 20oz drink with a value and im trying to paste the same value in the next sheet as a batch.

Thank you.

files attached

http://www.mediafire.com/?ii7r94g3qsen43c

http://www.mediafire.com/?s1ia5b43f887pfo

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
But which column set of other sheet ?

You can use vlookup too if you want
Some thing like this


=IF(ISERROR(MATCH(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$B,0)),"",VLOOKUP(A12,'C:\Documents and Settings\test\Desktop\[12.xls]12'!$B:$D,2,FALSE))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!