headache
11-05-2008, 12:06 PM
hi guys,
I am a VB beginner and tryed to find the solution in the search tool but I haven't, plus I am not english speaker, so sorry for my syntax
Anyway, here is my problem:
sheet (1)
A1: Robert
A2: 1
A3: 6
sheet (2) is my database
A B C D
reference analyst Pick up Booking
product 1, 2... robert, bill... 1,2,3... 5,10,14...
I want a code that replies to these conditions:
- name in the sheets(2), column B, cells B1, B2 etc until the end of the column, equal A1 (ie. "Robert")
- pick up in column C is greater than A2 (ie. 1)
- booking in colum D is less than or equal to A3 (ie.6)
For the products that match all these 3 conditions, I want to copy their references (cell in column A) and to paste them in sheet (1), A4.
I don't want to have blank cells below sheet (1), A4. I say that because first, I did a simple if(and) formula, but then I had some suites of 100 blanks cells and then 1 reference that matches the 3 conditions, then again 55 blanks cells and another ref etc, so not convenient to use even with a filter
I hope I have been clearer enough and will be delighted if you can solve that for me :p
Cheers mates
I am a VB beginner and tryed to find the solution in the search tool but I haven't, plus I am not english speaker, so sorry for my syntax
Anyway, here is my problem:
sheet (1)
A1: Robert
A2: 1
A3: 6
sheet (2) is my database
A B C D
reference analyst Pick up Booking
product 1, 2... robert, bill... 1,2,3... 5,10,14...
I want a code that replies to these conditions:
- name in the sheets(2), column B, cells B1, B2 etc until the end of the column, equal A1 (ie. "Robert")
- pick up in column C is greater than A2 (ie. 1)
- booking in colum D is less than or equal to A3 (ie.6)
For the products that match all these 3 conditions, I want to copy their references (cell in column A) and to paste them in sheet (1), A4.
I don't want to have blank cells below sheet (1), A4. I say that because first, I did a simple if(and) formula, but then I had some suites of 100 blanks cells and then 1 reference that matches the 3 conditions, then again 55 blanks cells and another ref etc, so not convenient to use even with a filter
I hope I have been clearer enough and will be delighted if you can solve that for me :p
Cheers mates