Hello,
Here is my question I have not been using excel for a few years but I am back and need to have a memory refresh
here is my delema
I have a excel spread sheet with 2 pages and on the first is where i want the data to populated, sheet1 has 2 columns. The first is blank and the second list a username the first is where i want the data i need entered
on the second sheet is a imported txt file broken down into columns and i am only concerned with the first 2
here is how i want it to work
sheet 1
column 1 column 2
??? username
??? username1
Sheet 2
column 1 column 2
testing username
testing username1
under username2
I want the code to look into sheet 2 in column 2 to find the username but if column 1 does not have the word testing then i do not want it to show
and if the word testing is there I will then want the code to display a "Yes"
In column 1 on sheet 1
any help would be great
Thank you
Here is my question I have not been using excel for a few years but I am back and need to have a memory refresh
here is my delema
I have a excel spread sheet with 2 pages and on the first is where i want the data to populated, sheet1 has 2 columns. The first is blank and the second list a username the first is where i want the data i need entered
on the second sheet is a imported txt file broken down into columns and i am only concerned with the first 2
here is how i want it to work
sheet 1
column 1 column 2
??? username
??? username1
Sheet 2
column 1 column 2
testing username
testing username1
under username2
I want the code to look into sheet 2 in column 2 to find the username but if column 1 does not have the word testing then i do not want it to show
and if the word testing is there I will then want the code to display a "Yes"
In column 1 on sheet 1
any help would be great
Thank you