hendrikbez
New member
- Joined
- Dec 13, 2013
- Messages
- 7
- Reaction score
- 0
- Points
- 0
I need some help with the following,
I have a excel file that I import 3 different files in each day, then I put all of them in one sheet, , on C I have Server names (now there are 3 of them, but it could get more)
The labels are at this stage 12 different ones. eg Pra001 to pra999 or aag001 to aag999, plus 10 more.
So what I need is that when I put a label number in A, it must put one of the 3 servers names in C.
I want to use an if statement, but I want to use it like PRA* or AAG* eg.
I then rename the sheet to today's date.
I have a excel file that I import 3 different files in each day, then I put all of them in one sheet, , on C I have Server names (now there are 3 of them, but it could get more)
The labels are at this stage 12 different ones. eg Pra001 to pra999 or aag001 to aag999, plus 10 more.
So what I need is that when I put a label number in A, it must put one of the 3 servers names in C.
I want to use an if statement, but I want to use it like PRA* or AAG* eg.
I then rename the sheet to today's date.