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
We would like to reformat the layout of an 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
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...
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
I'm using Excel. I have a sheet with values in non contiguous columns. I would like a macro or formula (if possible?) that would move the contents of the selected cells into the two cells to the left of the selected cells. On the attached sheet you can see that there are cells with numeric values in adjacent cells. These values can be under different
I need some graphic design. Brief: Create a standard Microsoft word and excel design scheme for our Solar Photovoltaic Solar Panel installation and leasing company’s RFP template. · The theme should be inspired by the solar photovoltaic business generally as well as the companies existing logo and provided stock photos. · To the greatest extend possible
Based on the Service Date and the Client Number, I need to find the total number of clients that got each specific s...clients that got All services Several Times a day and the Total Number of those clients in the whole period of time. The final result must be shown in excel sheets via Macro. Il will specify how excel tables will look like later.
I need a application will allow me to rank sport teams based on their win/loss record. The user will manual in...application will allow me to rank sport teams based on their win/loss record. The user will manual input the scores and the season schedule is read from an excel worksheet. I'm thinking a Excel VB Script macro. See attached requirements
I need a material procurement tracker in MS Excel format which has time stamping in it. I have already prepared everything else except the time stamping formula. Time stamping shall be probably done through Macro.