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.
...Menu Form: On opening the Database, you must have a Macro which runs and automatically opens the “Menu Form” in full screen view of the Menu Form, with no possible view or any other forms, Tables, Queries or reports, or any menus. Closing this form must only be possible using a button with a macro which will close the entire database. (After this is
...where I need to apply a macro - I’ve highlighted all columns and buttons in Yellow that I need to be worked on What I need: 1. The report tab: I need a macro, connected to button I7:J8 to pull the listed columns (these are in the same order and name as in the select tab and highlighted in yellow) in the Select tab. This macro should simply re-organize
...where I need to apply a macro - I’ve highlighted all columns and buttons in Yellow that I need worked on What I need: 1. The report tab: I need a macro, connected to button I7:J8 to pull the listed columns (these are in the same order and name as in the select tab and highlighted in yellow) in the Select tab. This macro should simply re-organize
I need a macro to automatically copy formulas based on the first row and paste it to rest of cells. Please find the two files. I have 40 files like this. The whole files need to go from step 1 to last step in matter of seconds.
Please look into the sample files. In every step it is just the data of the previous sheet and the same has been copied to rest of cells every time. I need a macro to go from step 1 to last step within seconds. I have 40 files like these.
Se desea crear una macro que de un conjunto de datos de una hoja lo pase a otra hoja siempre y cuando este seleccionada y que en esta nueva hoja lo divida en datos de 30 en 30 e incluya un boton que permita ir avanzando la lista e imprimir la lista actual y todas las listas con un solo boton. Tener presente que la macro debe ser automática, es decir
Hello All, I need some update with my current macro and summing up all the data in one excel spreadhsheet. I have tried to explain the work in the attached document. Only the best price will be awarded. I will be making the decision in 3 days, the maximum time to finish the project is also 3 days after awared.
Hello All, I have some data work in excel and PDF. For the first one, I already have a macro in excel, but the macro needs to be improved to add some additional data and then all the data should be summed up in one spreadsheet. For the second one, from specific pages in PDFs, some written data should be summed up in an excel documents.
I run a macro to send an email on a daily routine set in Windows Task Manager. I use Macro Recorder to build my macros ([url removed, login to view]). The macro imports into the clipboard the list of receipients from a .txt file. This allows me to update the list without having to play around with the macro coding. The script that does the
...several such projects for the right freelancer. Requirements: 1. Must have a Windows PC 2. Must be willing to install 2 programs that I will provide to you for free (Macro Express and Foxit PDF Reader) 3. Must be willing to download the PDFs I send you and upload the images that result from your work. The PDFs will be around 200 MB total.
Objective: We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run
Need an excel macro to get prices from website into excel
Financial/Business analyst ,Excel Macro expert needed for some task .
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format protection locked. Cell W38 has ...