Search Value by Column & Row

[gingank]

Could i have a macro that decide the row and column of the value and write it into another sheet ?

Please refer to the attachment. For you information the output sheet the information is fixed and just wan to grab the value from the raw data sheet.

I dun want to use the pivot table because all the total data need to x2 i want it do automatically so i no need to manually do the calculation and also the output product name is fixed already.
Could i done this by macro with do it using pivot because the actually data is large more than 100k row plus the serial number not owe by every product so i need to take care this to insert 0 for those didnt have the serial number
i dun wan to waste time to do the job manually.Book001.xls

[oeldere]

See how many questions of you being unanswered.

Normaly it means the question is not clear enough.

For this problem I found an macro to fill the data (empty cells in column A).

After that is easy to make an pivot table.

See the example.

Please reply, if this is what you're up to.