markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi guys, I just final bit of Macro code to sort this 65k line spreadsheet. I’ll try to explain it clearly
Column A has Ticket Number from A7 to A65k
Column B has a Category from K7 to K65k (typically Priority 1, Priority 2, Priority 3, etc.
Unfortunately, sometimes if a transaction is related to another ticket number it just puts the related ticket number in the category field rather than the category (it’s an issue with the system). The Category should be Priority 1, Priority 2, Priority 3 etc,
So as an example
Cell A7 contains Ticket Number 10101585 Cell K7 contains ‘Priority 1’
Cell A8 contains Ticket Number 10101586 Cell K8 contains ‘Priority 2’
Cell A9 contains Ticket Number 10101587 Cell K9 contains ‘10101585’ (which is the ticket number of the related call)
Cell A10 contains Ticket Number 10101588 Cell K10 contains ‘Priority 3’
Cell A11 contains Ticket Number 10101589 Cell K11 contains ‘’10101588 (which is the ticket number of the related call)
So every cell in column K should have a priority number Priority 1, Priority 2, Priority 3 etc. but sometimes (many times) it contains just a ticket number (as illustrated in K9 and K11 above). \
So using the example when the macro encounters a ticket number I need it to:
Please let me know if you have any questions.
Thanks in advance for you help
Mark
Column A has Ticket Number from A7 to A65k
Column B has a Category from K7 to K65k (typically Priority 1, Priority 2, Priority 3, etc.
Unfortunately, sometimes if a transaction is related to another ticket number it just puts the related ticket number in the category field rather than the category (it’s an issue with the system). The Category should be Priority 1, Priority 2, Priority 3 etc,
So as an example
Cell A7 contains Ticket Number 10101585 Cell K7 contains ‘Priority 1’
Cell A8 contains Ticket Number 10101586 Cell K8 contains ‘Priority 2’
Cell A9 contains Ticket Number 10101587 Cell K9 contains ‘10101585’ (which is the ticket number of the related call)
Cell A10 contains Ticket Number 10101588 Cell K10 contains ‘Priority 3’
Cell A11 contains Ticket Number 10101589 Cell K11 contains ‘’10101588 (which is the ticket number of the related call)
So every cell in column K should have a priority number Priority 1, Priority 2, Priority 3 etc. but sometimes (many times) it contains just a ticket number (as illustrated in K9 and K11 above). \
So using the example when the macro encounters a ticket number I need it to:
- Move the ticket number from cell K9 to cell 09 (so I keep the cross reference)
- Find the matching ticket number in Column A (in the example above it is in A7)
- Enter the original ticket number priority in Cell K9 (in the example above it is Priority 1)
Please let me know if you have any questions.
Thanks in advance for you help
Mark