ExcelBanter - Looking for values

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Looking for values (https://www.excelbanter.com/excel-programming/401923-looking-values.html)

Angeles

Looking for values

Hi , I have two worksheets , the sheet A and B, I have some columns in the
Sheet A , for example "Group A","Group B", "Group C",etc and I have value
List for each Col , The user can add new values per Col, and I need to copy
this new values in the sheet B , I have the same Name Cols in the Sheet B ,
so I need to look for the right column in the Sheet B , how can I use a Match
function from source code ?

Thank you in advance

Angeles

Looking for values

I have 112 Cols.

"Angeles" wrote:

Hi , I have two worksheets , the sheet A and B, I have some columns in the
Sheet A , for example "Group A","Group B", "Group C",etc and I have value
List for each Col , The user can add new values per Col, and I need to copy
this new values in the sheet B , I have the same Name Cols in the Sheet B ,
so I need to look for the right column in the Sheet B , how can I use a Match
function from source code ?

Thank you in advance

All times are GMT +1. The time now is 12:04 PM.