Aug 24 2022 03:26 PM
I'm creating an Excel document akin to a table of contents, with a numerical value in column A and an item in column C.
Reaching the end of the sheet, I continued on in column G as a continuation of A, and I as a continuation of C, to keep all the data on one page.
My dilemma is I need to be able to sort this document back and forth either numerically or alphabetically, at will, depending on need. Is there a way to link G to A and I to C so that A/G are treated as one column, and C/I are treated as one column?
Aug 24 2022 03:32 PM
I'd keep everything in columns A to C. With your current setup, it's far too complicated to sort.
Aug 24 2022 03:39 PM
@Hans Vogelaar Thank you for responding. Do you recommend going a different route to accomplish the same goal? Starting over from scratch is a viable option for me. I need to do this several times over and I'd like to get a game plan going before I dive in too heavily.
Aug 25 2022 12:11 AM
Just enter all numeric values in column A, one below the other., and the items in column C.
I'd enter headers in A1, B1 and C1, then turn on autofilter (select A1, then click Sort & Filter > Filter on the Home tab of the ribbon).
You can then easily sort and filter on each of the columns.
Aug 25 2022 09:40 AM
@Hans Vogelaar Ordinarily, I would do just that. However, in this instance, there are too many line items involved and I want to restrict this list to a single page, hence continuing on to an additional set of columns on the same page.
If there is no way to accomplish this, I will just do as we agree is the simplest method, sort, then copy/paste whatever ends up on the second page into an additional set of columns, then print.
Aug 25 2022 01:12 PM
I don't see a way to sort the data if you use non-contiguous blocks.
Aug 26 2022 12:24 PM