Excel VBA view/manipulate data

Question

Hi ,

I'm new to VBA programming and don't know the syntax. What are some of the useful VBA functions to view data in a file?

One thing I would like to do: have a button to create a new excel table based on a table in another sheet. The new table would only have some of the columns of the original table. Nothing else changed, just create an excel table (with the filter options etc. at the top) that only has a few columns of the original. Or maybe having this new table as query would be better (still in VBA though)?

How can I best perform a basic lookup in a table based on user selection? The user selects something, excel looks it up in the table and then returns a value from the same row as the selection.

Thanks!

Answer 1

Yes, that looks great :)

Is there a way to do that in VBA?

PS: Sorry for the late reply, I was travelling

Answer 2

..............have a button to create a new excel table based on a table in another sheet. The new table would only have some of the columns of the original table.

Hi,

Something like this, maybe ?

data in sheet1

pic1

results, in a new sheet

3 col. Name/Area/Population

pic2