Macro to read specific questions, and provide answers

Hi all,
I trying to do something in excel which sounds simple but may not be simple, hence, here I am

I have user(s) who will use this excel template -> sheet 1 to copy and paste data from a website. Sheet 1 will contain nearly 700 to 900 lines, when copied from excel. User has to grab certain information to create a record in the system. In sheet 2 I have listed the questions user will be looking for. In the result tab, you can see the output I intend to get.

Sheet has many questions, and answers to that is underneath that question in the same column ( I wish I have questions in column A and answers in Column B - can this be done by Macro?)
If above is not possible, in sheet 2 , I have listed questions for which user needs to find an answer from sheet 1.

Sheet 1 is not always consistent. For example: answer to the questions an be 2 lines, 3 lines. That depends. In this case, for question 2 , I have 3 answers (EFGH, IJKL, MNO), but it can be 4 or 2 depending on each record in the website.

Is there a macro, that would help me achieve what I have in result tab?


Thanks,
MaryFlower

I'm wondering if there is a better method of testing the user/s ?

Having so much information on different sheets seems to me like the first hurdle to overcome. Can the test be redesigned to make it simpler ? On one sheet ?


After that ... creating macro code to obtain the final results can be created.

Your thoughts ?

I am open to any ideas that will get the end result.
Everything that is in sheet1is literally copy paste from a pdf/web address. All I am trying to see is read only few section so I can start the process of creating a system record. Those sections are listed in sheet2.

Ideally, I would like for section (question) in column A, and answer to that in column B. Thanks

I've read ... and re-read your description in Post #1.

If I correctly understand, you are wanting the user to read some content that is posted on the Internet. Within that content is an answer you are seeking to the question
you have asked the User to answer. And ... to prove to you the User has actually located the material and hopefully read it ... you want the User to copy and paste the
relevant material from the Internet article to the Excel spreadsheet.

Is the above accurate or have I misunderstood the process ?

The first part is absolutely right.

My team members will have to go to the internet, read the announcements, collect data that would help them in moving the process forward. The website where posting is made has tons of information. My job is not to read them all but to only focus on certain sections that would help them to create a record in the system.

It is not to prove to me that they did their job because the first step in their day to day job is reading that, collect data, then start the work.

The automation here is - I dont want the user to go scroll, scroll, copy paste the sections or take notes manually. A macro would help here, I beleive. As an user, I just want to copy and paste the announcement in the internet in an excel template, run macro, and see all the information I needed, move on to the next one.

Sorry, if I have confused before. Hope this helps!

Thank you for taking the time to help me out.

You have said the information is posted on the Internet.

If that is accurate ... I apologize for my lack of knowledge implementing Excel with the Internet. I
do not have any knowledge in that area.

However ... now that we have focused on that as a need ... someone else on the Forum will most
likely be able to assist.

Please advise if I misunderstood about the "internet".

Thank you.

I go to the respective website, press ctrl A, copy, paste in excel. When is it pasted in Excel, it is all pasted in column A as opposed to column A and Column B.

The reason why I paste in excel is because it will allow me to have a macro or formulas that would clean it up and enable user to see everything they need without allowing them scroll many times.

Please don't apologize. You are trying to help and I am grateful.

Ok ... so the process does not involve website scraping ... which simplifies it completely.

You post a workbook in your original question but I don't feel it completely shows/explains how the process works. If you could post another workbook example ... this time
include one or two examples of the copy/paste website ... what questions would be involved with those website sections also.

Give us a "Before" and an "After" view of the process. Perhaps further explain what we are looking at and what the final product should be.
Maybe my skull is somewhat thick but I'm still not completely certain how the process unfolds.

😀
Sheet 1 is copy, paste from the website - "Before"
Sheet 2 lists the sections we look for
Result shows what the end game is - "After"

Sheet 2 is really to narrow down the sections we will be looking for so users see what is needed to be seen.

I can create another excel file, but wanted to share the above as well.

looking forward to the next workbook example

Sorry, took a longer time than expected.
Please see attached.

The first sheet is literally copied, paste from the website (https://grants.nih.gov/grants/guide/...AR-22-048.html)
The second sheet is my desired output. Highlighted are the sections I moved from column A and will be looking for.

Just wanted to check if I can get any help on this project. Thanks!