DDRA Steampunk
New Member
- Joined
- Feb 10, 2017
- Messages
- 23
Hi 
I usually use a formula that automatically updates the column header to a new number when I insert new columns into my insanely huge spreadsheet. With the new table autoformats I can no longer get this to work. Rather than hand number 50 columns, does anyone know how I might get around this? I could "untable" the data, but I actually use the sort feature quite frequently so I prefer to keep it. The issue really is that I need column A sortable. It's the item name with the list of ingredients in the rows. Column B is headed with recipe number (just 1, 2, 3, etc) and the costs per weight used of each ingredient (it looks up from another table) in the rows. The A B pattern repeats for 50 recipes in one table so I can get a total number of ingredients and costs row per recipe with a grand total at the end of the page. Any suggestions very much appreciated.
I usually use a formula that automatically updates the column header to a new number when I insert new columns into my insanely huge spreadsheet. With the new table autoformats I can no longer get this to work. Rather than hand number 50 columns, does anyone know how I might get around this? I could "untable" the data, but I actually use the sort feature quite frequently so I prefer to keep it. The issue really is that I need column A sortable. It's the item name with the list of ingredients in the rows. Column B is headed with recipe number (just 1, 2, 3, etc) and the costs per weight used of each ingredient (it looks up from another table) in the rows. The A B pattern repeats for 50 recipes in one table so I can get a total number of ingredients and costs row per recipe with a grand total at the end of the page. Any suggestions very much appreciated.
