harky
09-02-2019, 11:36 PM
This is my where i asked this question at, somehow is not what i want. Using excel formulas DO NOT allow to retain original value where i had copied from.
https://www.mrexcel.com/forum/excel-questions/1107659-vba-if-range-contains-cell-value-copy-than-del-2.html
*Need to retain original text format when copy cell.
If Column C cell contain 'Poster' or 'Index'
COPY "Col E Cell" to "Col A Cell"
And Delete Col E cell
or CUT & PASTE Col E to Col A
If Col C cell contain 'Poster' OR 'Index'
A
B
C
D
E
xxx
xxx
Poster
13
62131
xxx
xxx
Index
16
62141
COPY Col E Cell to Col A Cell Than
A
B
C
D
E
62131
xxx
Poster
13
62131
62141
xxx
Index
16
62141
Delete Col E
A
B
C
D
E
62131
xxx
Poster
13
62141
xxx
Index
16
https://www.mrexcel.com/forum/excel-questions/1107659-vba-if-range-contains-cell-value-copy-than-del-2.html
*Need to retain original text format when copy cell.
If Column C cell contain 'Poster' or 'Index'
COPY "Col E Cell" to "Col A Cell"
And Delete Col E cell
or CUT & PASTE Col E to Col A
If Col C cell contain 'Poster' OR 'Index'
A
B
C
D
E
xxx
xxx
Poster
13
62131
xxx
xxx
Index
16
62141
COPY Col E Cell to Col A Cell Than
A
B
C
D
E
62131
xxx
Poster
13
62131
62141
xxx
Index
16
62141
Delete Col E
A
B
C
D
E
62131
xxx
Poster
13
62141
xxx
Index
16