Data in a table

[newmind]

I need a visual basic code to pick up the data in a table. Please help!

 

[IRstuff]

Use the macro recorder on some manual operations, as a start.

TTFN

FAQ731-376

 

[IDS]

Does it have to be VBA? Using the ranges in your sample file the formula below will give what I think you want:

=INDEX($C$17:$Q$24,MATCH(H9,$B$17:$B$24,0),MATCH($B$9,$C$16:$Q$16))

If you do want to get the table data into a VBA array then give the table range a range name (say pipe_data) and create a VBA variable of variant type (that could be pipe_data as well) then:

Dim Pipe_Data as variant

Pipe_Data = range("pipe_data").value2


Will get all the data from your table into the VBA array.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[newmind]

Thanks Guys!

 

[newmind]

One more thing, another table problem of mine

 

[sdz]

Here's another solution without having to resort to VBA.
I try not to put too much into a formula because it becomes hard to understand.

 

[jghrist]

This doesn't find the next larger size for intermediate pressures, speeds, and capacities, but it should give you something to work with. Look at the values and formulas below the table. Note that I've named some cells to make the formulas easier to understand.