extract values within multiple sheets in 1 workbook.

[Aberdham]

Hi guys,

I am having a hard time trying to exact certain values from multiple Sheets. basically 2 Sheets contain all the description (data that i would like to extract) to the overview sheet. (all within an Excel file)

should it be possible to come up with a VBA code or formula to do the tricks?

would be grateful if any of you could help.

 

[MisterProzilla]

Hi, it depends on what you want to extract, but yep, pretty much anything is possible. If you're just wanting to return a value from one sheet into another, the easiest way to start is to just select a cell, type the equals sign, then go into your other sheet and click on the data you want to return and hit enter.

 

[Aberdham]

Thanks for your reply. that i know. the Problem is there are hundreds of entries. it would take days to look for the exact value then. what I am hoping is to have a formula or a vba code to do the trick.

 

[MisterProzilla]

No prob. Depending on what criteria you're looking for in the data you want to return, you might want something like either HLOOKUP, VLOOKUP, INDEX. Can you give more details on the data you're trying to look up?