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.
...Give an option to set the password. 6. Make sure that after installation all the macros will be displayed in a new Tab and List should be based on the functionality of each macro. 7. Custom made ribbon and icons are mandatory. 8. Help on each selection should be provided. Help text should be provided by the developer. 9. Debugging should be done free
I need to create a macro that formats a raw data coming as a text file, create several tables and graphs and then create a powerpoint slides with that information. the raw data change in size each week.
I need you to fill in a spreadsheet with data. I need an Macro and VBA expert to help with data extract，need to update accounting related excel based reports for the following features 1. Auto-predict dropdow that start showing values as soon as user starts typing. This should work same like the auto predict works on google search 2. Automated report
I have a sheet in excel and want to use a macro that creates an exact copy of that sheet but renames it (according to what i put in a dialog box when prompted) that works off of a button. Once I go to this new sheet I want to be able to make changes and use conditional formatting to highlight cells that are different that the other sheets. I have all
I have an excel spreadsheet of email addresses and order numbers. I need a macro that can parse the data and create a spreadsheet of the email addresses of customers that have ordered three or more times (meaning there are 3 different order numbers with the same email address).
I'm looking for someone who can take our current Wordperfect macros, and create templates in Word, to do the same thing that the Macros were doing in WP 15. There is no conversion process, so the wheels will need to be recreated. Long time WP environment, that is moving to Word.
I am looking for an Excel and VBA expert to create a spreadsheet capable of generating lists of names. For example, out of 8 names, I want a list created by choosing only 3 names at a time - which should produce a list totaling 56 combinations. It is a "n choose k" combination problem without replacement where order is not important. For the list, I would like flexibility in the total n...
I currently have a macro for an excel workbook that contains multiple worksheets to; 1. Set page settings including page margins 2. Prints worksheet to PDF and the file name is defined per cell A1 Once complete, the macro moves to the next worksheet and repeats process 1 & 2. Macro Enhancements... 1) I would like the macro to calculate (refresh)
I would like am excel, or numbers spreadsheet/ macro into which I can place 5-6 Heart data traces, along with the corresponding time stamp. The file should align the various heart rates according to time recorded, and display a graph as shown in the uploaded file - it is taking me hours every few weeks to produce these graphs, and there must be an
I want an excel VBA to send a PDF attac...excel VBA to send a PDF attachment through Whatsapp web to a phone number. My excel file will have the phone number and the path to the PDF (locally stored on my computer). The macro should be able to retrieve the PDF file and send it to the phone number indicated through my Whatsapp Web (I will be logged in).
I would like to create a macro that consolidates the following; > modify page setup settings (macro active) > print worksheet to PDF and file name as per A1 (macro active) At this point in time I run each macro individually for each worksheet. I would like to create a macro that consolidates the page setup and print to PDF for each worksheet and
Simple project. I need it to process all xls files in the directory, one by one. Directory is selectable the worksheet in all files is Sheet1 Select the date with datepicker format M/D/YYYY, this date goes in cell B8 Select week 1-5 are drop down selections. The 3 choices are Pending Holiday - When it saves the files it will create a new directory called Completed and save the f...
buenos dias necesito crear una macro u otra solucion en excel que tome una lista de nombres compare los que son iguales y me devuelva el nombre + un sufijo que los diferencie. por ejemplo: nombreZ nombreC nombreA nombreJ nombreC nombreJ nombreC nombreH nombreZ nombreC me devuelva la lista pero los repetidos agrega un sufijo quedaria
This is the first ...but within 1 column. We would also prefer to find someone with experience doing similar with pdf to excel. We are looking for someone who can do this easily enough with macro etc, that for 4,000 rows our cost would be $30 or under. **Must be available to start this weekend ** Must have a firm understanding of USA addresses.