I am consolidating a few years worth of scheduling data where one column represents a customer and the adjacent cell represents a service provided. The number of customers and service change each day. I would like to format the entire document to show one customer per line.
Currently I use Control "F" to find an individual customer, then I use the replace fxn to add in a color fill. I then look for the color that represents a customer on a given day and copy and paste both the customer and the service into the appropriate day of the year.
This is using a huge amount of resources and is very time consuming. Is there a better way to sort the data for a customer and service without moving it from the appropriate date and showing blanks where no service was performed on a given day?
Bookmarks