One cell and different formulas to display different data [VBA EXCEL 2007]

[londonpeter]

Hello everyone.

The idea is to enter articles numbers in to column A and run macro which will show me in the same cells data taken from vlookup.
I wish to make a few buttons for few macros. Each macro will replace article number with different vlookup value.

Is it possible to get vlookup result for "lookup_value" placed in the same cell?


A1 = 12345678
after macro
A1 = vlookup(12345678,table_array,column,FALSE)

Any clue? I will try to customize it to my spreadsheet.

I really appreciate all the help you gave me.

[Mallycat]

Why do you want to do this? You are making an easy task hard. Juat put your formula in a column next to your article numbers

[londonpeter]

This is more complicated.
I have got a map of articles on my shop floor. Articles numbers are entered in to some merged cells.

Image1.jpg

I wish to see different data (names, stock quantity, sales figures, etc,...) using few macro buttons.
Everything is working great but on separate sheets.

Image11.jpg

I am trying to make one map with all the information.

Is it possible?

[Mallycat]

I can't read the image files as they are too small.

[londonpeter]

I have attached file for easier understanding.

I am fine to stay with a sheet contains a map with articles numbers. And additional sheet where i can switch different views.MAP.xlsm

[Mallycat]

Try this

Please Login or Register  to view this content.