Melrose0507
New Member
- Joined
- Jul 19, 2011
- Messages
- 22
I have a spreadsheet with a lot of different data. In columns AR:AX which indicates days of the week there is either a "Y" or "N". I want to do a couple of steps.
1. identify lines that have more than one Y.
2. copy entire line to end of sheet.
3. In new line, change the first Y to N leaving remaining Ys alone.
4. Go back to the row below the line just copied from and continue to look.
I do not need to delete any Y's on original lines as other formulas will only look for the first Y in the row.
I am looking for a macro to do this. I am having troubling researching the correct formulas. Any assistance is greatly appreciated.
Thanks in advance.
1. identify lines that have more than one Y.
2. copy entire line to end of sheet.
3. In new line, change the first Y to N leaving remaining Ys alone.
4. Go back to the row below the line just copied from and continue to look.
I do not need to delete any Y's on original lines as other formulas will only look for the first Y in the row.
I am looking for a macro to do this. I am having troubling researching the correct formulas. Any assistance is greatly appreciated.
Thanks in advance.