Opening an Amazon site displaying ASIN selected.

Maybe the formula below works.

however wondering.

how can I have that automated whenever I I download a list of asin's, without having to bother each time separately?

also how do I define this as a link?

Hi Paul,

That seems to work!

I am receiving the following error when trying to fill in the entire sheet.

Any idea?

Hi,

is there any way for you to use "Visual Basic for Applications"?

The "formular-driven" way was never mine in Excel (sorry to state this!) ... everything is possible in VBA ... even using the sources behind WINDOWS (sripts)!

Best regards,

Raisor

"Any idea?"

There may be something not obviously wrong with the data in that cell in column A.  Skip that one and see if you can re-start the paste in the cell after it (or maybe skip a couple and try).  Beyond that, I don't know.

Hi,

Whatever I tried it didnt work.

Attaching the data, can you see whats wrong?

Thanks

EE.xlsx

Hi Paul,

to tell you ... many ideas ...

... VBA may/can/will do ... if you're able to provide some basic data records ... to let me build something … enabling you having a built sample!

Data is needed here to provide you a working sample!

Best regards,

Raisor