fairchance
Board Regular
- Joined
- Jan 4, 2015
- Messages
- 110
Dear Sir,
I have spreadsheet with column ID. I want to copy data from Raw data sheet to other six sheet on the following criteria:
1.If ID is single then these records may copied to 1 Referral
2.If ID column contains double IDs then these rows may be copied to 2 Referral sheet
3.IF ID.....................3 same values ............................................3 Referral sheet
4.............................................................................................4 Referral Sheet
5.............................................................................................5 Referral Sheet
6. If ID column contains 6 or more than six same values then............6 Referral Sheet
My worksheet is attached:
https://www.dropbox.com/s/qfh1v4sialdl69i/Referral Program Tracking.xlsx?dl=0
Kindly solve my problem and return the same after solution.
Regards
Shehbaz H.
I have spreadsheet with column ID. I want to copy data from Raw data sheet to other six sheet on the following criteria:
1.If ID is single then these records may copied to 1 Referral
2.If ID column contains double IDs then these rows may be copied to 2 Referral sheet
3.IF ID.....................3 same values ............................................3 Referral sheet
4.............................................................................................4 Referral Sheet
5.............................................................................................5 Referral Sheet
6. If ID column contains 6 or more than six same values then............6 Referral Sheet
My worksheet is attached:
https://www.dropbox.com/s/qfh1v4sialdl69i/Referral Program Tracking.xlsx?dl=0
Kindly solve my problem and return the same after solution.
Regards
Shehbaz H.