Hi,

Is it possible to take some values from clipboard
(or even show macro when something matching criteria is copied to it)?
Example:
I have in clipboard text:
xxxx product xx ET8888

and I want to copy xxxx into first empty cell in column A,
product into the same row, but next column,
xx into column C and so on...

On Jul 13, 5:25*pm, "Karol_tom" <Karol_...@wp.pl> wrote:
> Hi,
>
> Is it possible to take some values from clipboard
> (or even show macro when something matching criteria is copied to it)?
> Example:
> I have in clipboard text:
> xxxx product xx ET8888
>
> and I want to copy xxxx into first empty cell in column A,
> product into the same row, but next column,
> xx into column C and so on...

Paste the clipboard contents into a cell and then use Text to Columns
to parse the material