Jay Patkar has been a freelancer for four years now. He has worked on 300+ jobs. Now, he owns his own business and travels all over the globe.
I need a macro o something that will extract data from a lot of pdf files into excell. Those data are grouped in column and represent names, adress ,phone number and the employe that create the document. In atachment is a example of those documents. And i vill need an instruction how to use that macro or whatever.
...US. We are looking for an experienced and proven freelancer based in India to help us develop insightful whitepapers, blog posts and other marketing collateral that feature macro/industry/asset class/financial instruments research. The freelancer will work on the following projects: - Lead the creation of white papers / books to be published on
I have a CRM system where when leads come in at random times during the day. I need the system to take the email and phone number of that lead summary page and use a different browser like firefox to sign into a website with the email as user and phone number as password and log out again from the site. Its a basic step to be done but the browser needs to refresh every minute to see new leads an...
Write an excel macro that will create a .dxf file with 2D faces with holes according to coordinates and dimensions within excel file. The output should be able to create 5 faces. Similar to a folded-out-cabinet without the front/door. In excel there should be a checkbox or a function to select which faces you want to output to the dxf. If not checked
I need to create an automation/macro that takes information from a website database (always the same way it is presented) and fills them into an exl sheet. and if possible also download the file that is attached there. See attached document of the browser site on the right and the exl on the left...
The Excel contains an inventory of projects, which are updated on a weekly basis. There are two processes: 1. New project input, which contains a number of standardized and nonstandardized data. 2. Update project, which on a weekly basis, users, should update their projects. --- Here is where the process is not working well.
Each month I receive an Excel report. I want to combine all the monthly reports into one worksheet of one workbook. The 1st step is to write VBA code to run in the personal macro workbook which will organise this report into an Excel table. The report is not organised into neat columns. It has been designed to be printed out, page by page and viewed
...existing excel document to allow for A4 portrait printing. In addition to this, on the Summary Page, we would like to add a Macro that will enable us to insert new Tabs along the bottom (named VAR-00***) etc, and a Macro that will add a new line item into the into the list that includes a hyper link to the relevant tab. The tabs named VAR 00**
I have an Excel workbook set up to look like an internal work order that we already use. I need to have a VBA or Macro or something that combines the information from our online orders into the work order that I made. The hard part is getting the information into the right areas of the work order. A lot of the information in work order will need to
Preciso de um software para controle dos tiros (recoil) das armas de um determinado jogo, cerca de 12 armas. O software é simples, cada arma terá seu código de ativação como f1 f2 f3 e assim vai, e quando ativado cada vez que o usuário clickar com o mouse o software vai fazer o movimento para controlar os movimentos de disparo das armas. Seria bom ser p...
...sheet. This requires a criteria and extraction area with some filtered data 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add at least two different data validation fields 13. Create 2 charts of different
I need help with a Visual Basic macro that references information from Excel column A and column B and then calculates a value for column C. Then moves to the next row and does the same thing. This process needs to loop until complete. It doesn't seem like this would be too complicated, however, I have no programming knowledge. Thanks in advance
I need a macro that checks when data entry in forms comply with pre stablished requirements stored in a SQL table: FORM/Field/Warning/Type/Restriction New cost/Amount/Warning type A/Range/>=0 and <=1000 New warehouse/Code/Warning Type B/Format/CO### etc... with Warning A: don't allow data entry Warning B: allow but send mail to supervisor
I have a list of 20 or more RDP(IP, User,Pass), I want a macro to connect the RDP's and copy all files from C:test folder from my local computer and run the [url removed, login to view] from copied files, The text file that contain RDP information maybe change later. My budget is: 350$ and time is: 2days