tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Every two months I get a list of new data the I need to replace some of my old data with.
I have figures in Range C2:C700 and Products in Range E2:E700
In Column J2:J700 I have either "No Update", Blank, or New Data,
I'd like a macro that when run could go through each row and if J does not contain either "No Update", Blank, Over write Column C with whats in column J and column E with whats in Column K
Please help if you can.
Thanks
Tony
Every two months I get a list of new data the I need to replace some of my old data with.
I have figures in Range C2:C700 and Products in Range E2:E700
In Column J2:J700 I have either "No Update", Blank, or New Data,
I'd like a macro that when run could go through each row and if J does not contain either "No Update", Blank, Over write Column C with whats in column J and column E with whats in Column K
Please help if you can.
Thanks
Tony