Enter data from excel to an online form - vba / macro excel
- or -
Post a project like this£300(approx. $373)
- Posted:
- Proposals: 21
- Remote
- #2046697
- PRE-FUNDED
- Expired
Transcription, Fillable PDF form,PDF conversion,PDF Editing,Adobe Acrobat,Data Entry, typing, MS word And MS Excel, Writing
Delhi
data entry,copy and paste copy formating, copy editing, photoshop,data based copy online exel work , form filling data
Kalol
PDF Conversion, PDF Editing, Transcription, Adobe Acrobat, Typing, Data Entry, Ms Word, Ebooks Formating, Fillable Pdf Form
Delhi
Linux Server Administration & Security | Technical Support | Clean Malware | WordPress | Website & Email Migration | SSL Setup
Bay Minette
17926942274187227240522718962263806226064022521462248447220941221302631932614102511
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Here is an example of how I would like the code to work, bit more complicated process than the one shown in the video but at least it gives you an idea:
https://www.youtube.com/watch?v=5PohYtAYQuU
I need a VBA code for the following process....hopefully it makes sense:
1. Once logged on to the website. I would need the code to work on an online search box that is based on a certain web page on the site.
2. The code would input the reference of a certain cell from a row in an excel spreadsheet, and only enter it into one part of the form.
3. A search would then take place and to see if there is already a reference held on the websites system – you need to click a button to do this. If a reference is not found it will say at the top of the webpage.
4. If there is no reference found on the system add the term ‘No reference found’ to an empty cell on the same row. Then go to the next row down and search for a new reference. Continue this till a reference is found.
5. When a reference is found on the system you are then taken to another web page.
6. From there I only want the system to select the hyperlink which takes you to another web page if there is only 1 year that needs updating and it is in the 2018 year. I am not sure whether you find out what year it is – whether it is before you click the hyperlink or after it when you get taken to the new form, I am not sure of I would have to get back to you on that.
7. If the above criteria are then met I would then want the code to enter specific cell information from the same row the reference into certain parts of the new online form. In some of the cells contain amounts e.g 1769.56 – this number would need splitting into an integer (1769) in one part of the form and the decimal and decimal (56) in another part of the form. Certain cell to certain of the form. No duplications.
8. There are different cells on the excel spreadsheet that contain number that need this doing to this also. If it would be easier to amend the excel spreadsheet first than letting the code split them between integers and decimals then I could do that.
9. There will be certain parts of the form kept blank. I would then want the online form submitting by clicking on a button at the bottom of the page. Once it has been submitted it stays on the same page and a message at the top of the page says it has been submitted successfully. I then want this page to be printed as a pdf and saved under a cell reference name that is on the same row as the original reference we search for.
10. I then want an empty cell on the same row the reference was found that a form had been submitted for to have entered ‘Submitted’ into it.
11. Then automatically go down to the next row and search for the new reference by going to the web page where you do a search. Beginning the loop again.
12. Sometimes the form is not able to get submitted because there is an issue with the numbers entered. If this happens I then want an empty cell on the same row the reference was found that a form had been submitted for to have entered ‘Please check’.
13. Then automatically go down to the next row and search for the new reference by going to the web page where you do a search. Beginning the loop again.
14. When there are no rows left to check stop the process.
It could be that I split the the VBA code into two separate codes.
For example the first code works by itself:
1. Once logged on to the website I would need the code to work on an online search box that is based on a certain web page on the site.
2. The code would input the reference of a certain cell from a row in an excel spreadsheet, and only enter it into one part of the form.
3. A search would then take place and to see if there is already a reference held on the websites system – you need to click a button to do this. If a reference is not found it will say at the top of the webpage.
4. If there is no reference found on the system add the term ‘No reference found’ to an empty cell on the same row. Then go to the next row down and search for a new reference. Continue this till a reference is found.
5. When a reference is found on the system you are then taken to another web page.
6. When the reference is found on the system add the term ‘On the system’ to an empty cell on the same row. Then go to the next row down and search for a new reference on the webpage where you do the search. Continue the loop until no more rows are left.
https://www.youtube.com/watch?v=5PohYtAYQuU
I need a VBA code for the following process....hopefully it makes sense:
1. Once logged on to the website. I would need the code to work on an online search box that is based on a certain web page on the site.
2. The code would input the reference of a certain cell from a row in an excel spreadsheet, and only enter it into one part of the form.
3. A search would then take place and to see if there is already a reference held on the websites system – you need to click a button to do this. If a reference is not found it will say at the top of the webpage.
4. If there is no reference found on the system add the term ‘No reference found’ to an empty cell on the same row. Then go to the next row down and search for a new reference. Continue this till a reference is found.
5. When a reference is found on the system you are then taken to another web page.
6. From there I only want the system to select the hyperlink which takes you to another web page if there is only 1 year that needs updating and it is in the 2018 year. I am not sure whether you find out what year it is – whether it is before you click the hyperlink or after it when you get taken to the new form, I am not sure of I would have to get back to you on that.
7. If the above criteria are then met I would then want the code to enter specific cell information from the same row the reference into certain parts of the new online form. In some of the cells contain amounts e.g 1769.56 – this number would need splitting into an integer (1769) in one part of the form and the decimal and decimal (56) in another part of the form. Certain cell to certain of the form. No duplications.
8. There are different cells on the excel spreadsheet that contain number that need this doing to this also. If it would be easier to amend the excel spreadsheet first than letting the code split them between integers and decimals then I could do that.
9. There will be certain parts of the form kept blank. I would then want the online form submitting by clicking on a button at the bottom of the page. Once it has been submitted it stays on the same page and a message at the top of the page says it has been submitted successfully. I then want this page to be printed as a pdf and saved under a cell reference name that is on the same row as the original reference we search for.
10. I then want an empty cell on the same row the reference was found that a form had been submitted for to have entered ‘Submitted’ into it.
11. Then automatically go down to the next row and search for the new reference by going to the web page where you do a search. Beginning the loop again.
12. Sometimes the form is not able to get submitted because there is an issue with the numbers entered. If this happens I then want an empty cell on the same row the reference was found that a form had been submitted for to have entered ‘Please check’.
13. Then automatically go down to the next row and search for the new reference by going to the web page where you do a search. Beginning the loop again.
14. When there are no rows left to check stop the process.
It could be that I split the the VBA code into two separate codes.
For example the first code works by itself:
1. Once logged on to the website I would need the code to work on an online search box that is based on a certain web page on the site.
2. The code would input the reference of a certain cell from a row in an excel spreadsheet, and only enter it into one part of the form.
3. A search would then take place and to see if there is already a reference held on the websites system – you need to click a button to do this. If a reference is not found it will say at the top of the webpage.
4. If there is no reference found on the system add the term ‘No reference found’ to an empty cell on the same row. Then go to the next row down and search for a new reference. Continue this till a reference is found.
5. When a reference is found on the system you are then taken to another web page.
6. When the reference is found on the system add the term ‘On the system’ to an empty cell on the same row. Then go to the next row down and search for a new reference on the webpage where you do the search. Continue the loop until no more rows are left.
LUKE M.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
24 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies