Search and copy cells across Sheets, NEED URGENT HELP!!!

[pringle1987]

Hey Guys need some help copying cells, will try explain my process as good as possible. It is across 2 sheets.

The cells I want to fill are in coloumn V in sheet 2. ie v10, v11, v12, etc.

On sheet 2 column d comtains an item count and V is the count of that item.

Then on sheet 1 column ranges (B4 To B49) (G4 To G49) (L4 To L49) (Q4 To Q49) containt the relevenant item code to column D on sheet 2. Also on sheet one the count section that I want copied into V on sheet 2 which is columns D,I, N,S 4-49 etc..

My issue is that sheet 1 is constantly rearranging and sheet 2 is in numerical order of column D.

So how do I get sheet 2 V10 to populate by searching for the item code of D10 on sheet 2 in B,G,L,Q of sheet 1 then once located to then copy the contents of the number from D,I,N,S that works with the item list?

Then once done this that I can copy the formula all the way down column V in sheet 2?

I hope this makes sense

[Pete_UK]

It is much easier to describe if you attach a sample workbook, and then we can play about with different approaches and give you something that works.

The FAQ describes how to attach a file to one of your posts.

Pete

[mikeTRON]

Index+match seems like it might be the key but yeah if you post a sample workbook this is probably a very simple task.

[pringle1987]

Sorry guys thanks for the response, attached is a copy of a sample of my above. Hope this helps and makes sense etc?

[aydeegee]

Hi pringle1987

I hope this makes sense

well, actually, it doesn't. That is, not for the first 3 or 4 times of reading. However, let me see if I have this correct.

The cells I want to fill are in coloumn V in sheet 2

This would be the sheet cunningly called "Sheet1" ?

On sheet 2 column d comtains an item count

Should this read "sheet 2 column d comtains an item reference" ?

Then on sheet 1

that is NOT the one called "Sheet1" but the one called "Count Sheet"

If you can confirm that my guesses are correct, I am sure that someone can help. Note that the confusion causes most people to give up so you are unlikely to get an "urgent" response.

Regards
Alastair
(likes a challenge)

[mikeTRON]

These reasons are exactly why I didn't respond, and wont respond until things are clear and atleast aligned with one another.