Copy the data of a sheet that contains a column error mark to another sheet

leap out

Active Member
Joined
Dec 4, 2020
Messages
271
Office Version
  1. 2016
  2. 2010
Hello
I want to copy the data of a sheet containing an error mark and ignoring a valid mark based on column D with the same formats.
with a note that the update in the output sheet must be based on the update in the input sheet when the code is run every time without duplicating copying the data that has already been copied , but if The data was changed in the input sheet, which was previously copied to the output sheet, then it is changed in the output sheet.
before
CO.xlsm
ABCDE
1ITEMBRANDQTYCONDITIONRESULT
2115W40 12x1L18ü0
3210W40 12x1L40û39
4310W40 4x5L11û-11
5410W40 4x1L9ü0
655W40 4x6L4û-40
765W40 4x4L4û-16
875W40 4x5L45û-5
9820W50 4x4L8û-1
10910W40 208L1û-54
111015W40 208L33û13
12115W30 208L21û11
13125W30 12x1L10ü0
141320W50 4x1L4û4
INPUT
Cell Formulas
RangeFormula
D2:D14D2=IF(E2=0,CHAR(252),CHAR(251))




after
CO.xlsm
ABCDE
1ITEMBRANDQTYCONDITIONRESULT
2110W40 12x1L40û39
3210W40 4x5L11û-11
435W40 4x6L4û-40
545W40 4x4L4û-16
655W40 4x5L45û-5
7620W50 4x4L8û-1
8710W40 208L1û-54
9815W40 208L33û13
1095W30 208L21û11
111020W50 4x1L4û4
OUTPUT
Cell Formulas
RangeFormula
D2:D11D2=IF(E2=0,CHAR(252),CHAR(251))

note : XL2BB tool doesn't show tick right, wrong
 
Last edited:

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Here is the pictures
12.PNG



result
13.PNG
 
Upvote 0

Forum statistics

Threads
1,215,583
Messages
6,125,665
Members
449,247
Latest member
wingedshoes

We've detected that you are using an adblocker.

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.
Go back
Back
Top