checking value in cell and then pasting to a specific worksheet

[jbcpfc]

hi,


so here's what I'm attempting to do is to, I need to check a cell to see if the first two characters in that cell match one of three things. once I have checked that I then need to copy that range of cells and then paste it into a specific worksheet. I have been told use InStr and if's to do it but Im struggling to code it. I understand how to copy paste data from one sheet to another but its the checking part im not 100% sure of can anyone help?

[Mumps1]

What cell or range of cells do you need to check and what 3 strings do you need to match? What is the name of the specific sheet and where on that sheet do you want to paste the copied data?

[jbcpfc]

so in a worksheet I have a list of staff members that all belong to different companies. each id has 2 letters which need to be checked. the letters are BC , IA and AC. once they have been checked I need to copy the staff id the name of the staff member and the role and place it into the respective worksheet for the company they work for. I have been asked to do this in vba using InStr and if but as im not confident with vba im not sure how to do the checking. tried looking online put got more confused

[Mumps1]

I would need more details to suggest a code that will work for you. In which columns are the staff id's, the names of the staff members and their role? What are the names of the company worksheets?

[jbcpfc]

staff numbers start from cell b4, staff names start from c4 and roles start from d4. names of the worksheets are Agenda Corporation, Borough Capital and ICN Agency

[Mumps1]

I have to go out for a bit. I'll get back to you as soon as I get back.

[Mumps1]

Try:

Please Login or Register  to view this content.