Thank you very much.
That looks great but how did you delete table headers. When I selected table headers and selected Delete Table Columns, the process deleted all content in every column in the selected table, not just headers.
PS: I do want to keep description headers, such as:
Morning...
Hi Nebu,
For some reason, I didn't even think about using 3 tables on each spreadsheet.
My manager wanted a button on each day spreadsheet (day 1 to day 11) to insert a new row for specified meal time (breakfast, lunch, or afternoon tea); however creating 3 tables without headers on each...
As you'll see there are 11 spread sheets in the workbook, plus three I used for testing (JohnTest, JohnTest2, and FoodList). Each spread sheet will have 3 define name lists/tables, and some way of adding a new row to each named list by either a button or a drop down list. Each list will have 5...
I need to add/insert a new row at the end of a named range (defined name) to expend the named range and copy formula from the row (4 cells) above to inserted row using Excel VBA.
There are three named ranges on the spreadsheet, 11 spreadsheets in the workbook and I would have insert new rows...