Hi Everyone,
Can someone help me out on the below ..
1. I have 3 tables in sheet1 with the headers from A to F column.
2. I need to name a cell name as "Type" if my next cell name contains as "Data" which will appear anywhere from A to K however i need to repeat the same step for Table 2 and Table 3 headers. Attached snapshot for reference.
Thanks.

Can someone help me out on the below ..
1. I have 3 tables in sheet1 with the headers from A to F column.
2. I need to name a cell name as "Type" if my next cell name contains as "Data" which will appear anywhere from A to K however i need to repeat the same step for Table 2 and Table 3 headers. Attached snapshot for reference.
Thanks.

