I am at the point of pulling all my hair out.
I found many VBA scripts, but they are more for Sheets rather than workbooks and having to provide a path to the Workbook. If I send it to someone else, then the script will be invalid because the path is no longer valid, correct?
Some of the script were so long and complicated that for a newbie like me, I was lost as to where or how I could tailor it to my needs.
Here's what I am trying to accomplish:
I found many VBA scripts, but they are more for Sheets rather than workbooks and having to provide a path to the Workbook. If I send it to someone else, then the script will be invalid because the path is no longer valid, correct?
Some of the script were so long and complicated that for a newbie like me, I was lost as to where or how I could tailor it to my needs.
Here's what I am trying to accomplish:
- Compare 2 Workbooks: Compare the current Workbook with a new Workbook.
- Columns L & M are the columns that are to be compared, starting on row 4, in both Workbooks. So in other words WB1 L&M compared to WB2 Columns L&M.
- Is it better to add a blank column to add the new data or copy all changed rows to a new sheet?
Last edited: