Hi guys,
wanna know if you guys could help me write vba code.
I have a file with 2 tabs. Tab 1: London Vigs Tab2: FILE
Ideally, I'd like all rows from tab 1 containing the wording: (DONE) in column A, to be copy/pasted onto tab 2 (FILE)
for instance
A1: car (DONE)
A2: bike (DONE)
A3: cylce
A4: bus
only row 1 & 2 should be copy/pasted onto tab2 because of the wording (DONE). data from row 3 & 4 are not copy/pasted.
thanks for your help dudes
Mike
wanna know if you guys could help me write vba code.
I have a file with 2 tabs. Tab 1: London Vigs Tab2: FILE
Ideally, I'd like all rows from tab 1 containing the wording: (DONE) in column A, to be copy/pasted onto tab 2 (FILE)
for instance
A1: car (DONE)
A2: bike (DONE)
A3: cylce
A4: bus
only row 1 & 2 should be copy/pasted onto tab2 because of the wording (DONE). data from row 3 & 4 are not copy/pasted.
thanks for your help dudes
Mike