navic
New member
- Joined
- Aug 27, 2013
- Messages
- 901
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
If I understood you, I have solved the problem using the formula. It might help this my ideaI have spreadsheet with column ID. I want to copy data from Raw data sheet to other six sheet on the following criteria:........................Kindly solve my problem and return the same after solution.
On the worksheet Raw_Data I have added an extra column in front of your data
The cell 'A1' I put a the drop down list that allows you pick a column as a condition
The cell 'A2' I put a formula that compared the condition as a result returns the number of repetitions of data from the same row in column conditions. Copy the formula to the last row
On the other worksheets, where you want to have results (1_referral, 2_refeerral etc ...) I also added an assist column at the beginning.
In cell 'A1' I put a formula that automatically returns a number from the name of the worksheet (from tab sheet)
In cell 'A2' I put a as a result of a formula that returns data for the defined condition in a cell 'A1'. Copy this formula to the right until the last column and then down
See my example files