englandmark
Board Regular
- Joined
- Apr 9, 2015
- Messages
- 62
Help needed,
Goal - Move cells data from one worksheet to next blank row to cells in another worksheet when criteria from first sheet is met.
Entry worksheet named 2018 Call Log, copy data and paste to worksheet Sales Log next blank row
Criteria to be met in worksheet 2018 Call Log column L is Mitch
Capture data from same row from column D and copy and paste to worksheet Sales Log column B
Capture data from same row from column F and copy and paste to worksheet Sales Log column C
Capture data from same row from column G and copy and paste to worksheet Sales Log column D
Capture data from same row from column H and copy and paste to worksheet Sales Log column E
Capture data from same row from column A and copy and paste to worksheet Sales Log column F
Capture data from same row from column I and copy and paste to worksheet Sales Log column G
Capture data from same row from column K and copy and paste to worksheet Sales Log column O
Capture data from same row from column L and copy and paste to worksheet Sales Log column J
Thanks in advance
Mark
Goal - Move cells data from one worksheet to next blank row to cells in another worksheet when criteria from first sheet is met.
Entry worksheet named 2018 Call Log, copy data and paste to worksheet Sales Log next blank row
Criteria to be met in worksheet 2018 Call Log column L is Mitch
Capture data from same row from column D and copy and paste to worksheet Sales Log column B
Capture data from same row from column F and copy and paste to worksheet Sales Log column C
Capture data from same row from column G and copy and paste to worksheet Sales Log column D
Capture data from same row from column H and copy and paste to worksheet Sales Log column E
Capture data from same row from column A and copy and paste to worksheet Sales Log column F
Capture data from same row from column I and copy and paste to worksheet Sales Log column G
Capture data from same row from column K and copy and paste to worksheet Sales Log column O
Capture data from same row from column L and copy and paste to worksheet Sales Log column J
Thanks in advance
Mark