Help :macro to name a cell

[Revathi kannan]

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.


Capture.PNG

[Mumps1]

The screenshot you posted looks like sample data. Most often a macro that works with sample data will not work on the actual data. Could you attach a copy of your actual file rather than a screenshot? It's difficult to work with a screenshot. If the workbook contains confidential information, you could replace it with generic data. Explain in detail what you want to do using a few examples form your data and referring to specific cells, rows and columns.

[Mumps1]

Cross posted: https://www.mrexcel.com/forum/excel-...name-cell.html
Please see Rule #3 here.