Hi,
I am a novice in VBA and still learning and would appreciate any help I can get.
Issue: I need to write a macro that will copy two columns of data if a condition is met. The condition is "Tall" in column 2 in Sheet1. If "Tall" exist in Column2 then copy Column 4("Name") and paste it in Column 16("Name") on Sheet2. Then copy column 14 ("Amt") and paste it on column 22("Amt") on Sheet2.
Then I want to keep doing this until I have copied columns 24-29("Amt") into Sheet2 Column22.
I have tried to write a macro but have had no success. I have written the macro to copy two different Amt columns but no success.When I run the macro nothing happens. Not even a message error appears. I have attached my workbook.
Please let me know if you have any questions.
Thanks!
Bookmarks