Forum Discussion
combine cells in rows
BillH80 Start by deleting empty rows (like the one between the header and the first row with data) and columns in your data (like the two before the due date). Then, you can sort any column of your choice and the other columns will follow. More about sorting in the link below:
Riny_van_EekelenThanks for the reply but not sure it fixes my problem. I have attached the form I am using that has some notes on it. Maybe this will clarify what I am doing?
BillH80 Sorry, but pictures aren't very helpful. Difficult to judge how "the other worksheet" influences what you want to achieve.
Riny_van_EekelenOk, I have attached the file. The sheet "To Do" is the one I need to fix. The rows in Column A are formulated to sort in the same order as column D in sheet "Sheet 1". When I manually sort sheet 1 it rearranges To Do sheet Column A to match. I want the info in column B through H to stay with the name in column A. Help?