Data from Column to Named Cells

[Jonathan78]

Hello,

I have the following data on sheet1.

-22P PMC72464TS PVG 1735
-23P PMC69290TS TSN 1460
-31P PMC70090TS TSN 1990
-32P PMC73917TS TSN 1580

On sheet2 I got cells named 22P, 23P etc.
They are however scattered all over the sheet.

Is there a way in VBA to get the data from the second column on sheet1 (PMC72464TS, etc) in the named cells (22p, 23P etc) on sheet2.
The second step is to get the data from the 3rd column (pvg, tsn, etc) to the cell below the named cells.

Any help is welcome.

[nilem]

maybe something like this

Please Login or Register  to view this content.

The data in the first column and the name of the named ranges must begin with an underscore.

[Jonathan78]

Wow Nilem!
Thank you so much!
It works great!