Ok here is the situation, i have a worksheet with multiple sheets in it and Column A in all the sheets has Client Names and the rest of the columns have diff types of data about them depending on the sheet. so if a new client comes in I have to update Column A one by one in all the sheets to avoid messing up the rows for existing clients.
is there a way through which i can map column A to all my sheets, so that if i have to add a new row for a new client all the other sheets auto-update themselves with this new row addition.
HELP!!!
is there a way through which i can map column A to all my sheets, so that if i have to add a new row for a new client all the other sheets auto-update themselves with this new row addition.
HELP!!!