Hi
I have a table of data in excel. I have recently changed it to a table as this was the required format for a BI reporting tool. Some of the formulas have been changed since using the table feature and now appear as a structured reference formula. Others have the usual formula denotation. One column is a structured formula and it finds the area on a lookup table on another tab, which returns the area linked to a sales manager. In the past - areas and sales managers have changed, so I hardcoded the data before the change - and anything new say from row 3000 uses the formula. For any new rows that are added to the spreadsheet, I would like the formula to pull down but it is not doing this and I think its because there is hard coded data in the column. Do you have any solutions to get around this so I don't have to drag the formula down manually each time?
Many thanks in advance!
Bookmarks