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. Di...Completed and save the files in it. It will be a sub directory of the directory it was working in. The saved filename will be created from the date picker selected date and from data in the Cells B12 and D12 The new file name will be YYYYDDMM B12 D12
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
...feed into our payroll software. The output from the time and attendance system gives an excel sheet with raw data. Each line consists of a shift that was worked along with a load of data associated with that shift including length and base payrate. That raw data is pulled into a consolidated shift sheet that pulls in info about the shift and about the
vba/ macro auto create tab, dropdown and sheet based on data. i have excel file, i would like to create macro/vba to refresh/create tab, dropdown, sheet based on 1 tab called data1. let me know if i can call to make it eaier to explain
...shows turnover of each Quintile of products over a specified period. Please see attached file ([url removed, login to view]) for detailed information regarding this project All the data needed to complete this project is present in [url removed, login to view] file (please see attached file) IMPORTANT: This job *MUST* be done using R programming language ONLY! I need the
I need a page, or pages, that has a 7 question test. The users answer the 7 questions correctly and then the site confirms their answers. It doesn't have to be pretty, just functional. Here is a rough draft of what I want. [url removed, login to view]
I need a staff rotation schedule coded and designed to work in excel 2010, i already have one done but it only works properly in excel 2013 and upwards, please let me know if you can do this? I can send you the file so you know what you have to do... if you dont have excel 2010 dont bother to bid please....
I have a PDF document with 800 pages. Each page belongs to each employee. You should develop an excel based macro to Extract PDF Pages and Rename Based on Text in Each Page (Content on the PDF). Looking for experts who have experience in this.
I need a macro that loops through multiple csv files in a folder (path) that compiles all the data in the csv files to a single worksheet in an excel workbook. I need the general macro allowing me to set the path of the csv files and the range to be copied.