Hello,
I've been using the following successfully but now want to modify it to only copy certain columns versus the entire row. I've read various threads but stuck how to include a range or identify specific columns.
Thanks in advance for your help!!
-Bob
Sub CopyRowBasedOnCellValue()...
Hello all!
I need to write some VBA to copy specific columns from closed source book to open workbook. I have most of it completed i am stuck on how to add columns to copy and location to paste. I would like for the data in the destination workbook erase the data in the respective columns...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.