I am currently working on a database in Excel.
I often move from Worksheet to Worksheet, however every time I add a new entry with a last name identifier in Row A, I need the name to be added to each worksheet.
Right now, I am manually adding each name. Is it possible to have entries in Column A automatically populate, when a new entry is made?
I often move from Worksheet to Worksheet, however every time I add a new entry with a last name identifier in Row A, I need the name to be added to each worksheet.
Right now, I am manually adding each name. Is it possible to have entries in Column A automatically populate, when a new entry is made?