clipboard

K

Karol_tom

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...
 
J

James Ravenswood

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...
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating only a portion of both row and column on multiple pages 1
can't paste from clipboard in my macro 1
Cannot empty the clipboard 5
Template 4
Select and Copy data in column. 3
clipboard pastes wrong item 1
Macro - To Include Summing All Similar Entries 1
Macro to paste x number of times 4

Top