Forum

How to Find - Copy ...
 
Notifications
Clear all

How to Find - Copy and Paste certain Entries Derived from a Web Page

3 Posts
2 Users
0 Reactions
102 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello everyone my name is Maurizio, and my problem is this.
On an excel sheet in cell (A3: A30) I insert a series of entries: For example:
( Sun
Sunny
A bit cloudy
Fog
Rain
Snow In High Altitude
Scattered Rain
Very cloudy
) etc...!

While in column (E2) some items are written such as: "kiwi, figs, very Cloudy, Sunny" etc ...!

That said: I would like all the matches found in cell (E2) to be copied into column (C3: C30)

Let me explain: Since in the Cell (E2) of my original work, the original data of the Weather forecast are reported from a web page.

I would like only certain data to be extracted, taken from the list in the column (A3: A30); minus everything else that doesn't interest me.

Therefore, once the verification has been made between the data entered in cell (E2) and those entered in the column (A3: A10)
Such Real data should in turn be entered in the Column Only (C3: C30)
That's all !
There is a way to achieve this; In VBA?
Thanks in advance for all the help you want to give me on this. Greetings from Maurizio

 
Posted : 24/03/2021 5:40 am
(@questvba)
Posts: 125
Estimable Member
 

Hi, Maurizio,

Here is a solution on Foglio3 with VBA.

BR,

Lionel

 
Posted : 24/03/2021 11:18 am
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello Lionel Baijot
I have to give you my sincere compliments on your work
Me with all my good will
Couldn't I have done all this?
You are a genius ; Let me tell you.
Although I have no words to express my gratitude towards you:
I'll just tell you Thanks
Sincere greetings and good day; With Sympathy and Friendship by A.Maurizio

 
Posted : 25/03/2021 6:56 am
Share: