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
...many, we are looking to build a relationship with someone who can help us format some csv files into the correct product. Right now, we have approximately 3-4,000 rows of spreadsheet data that needs the USA street addresses compiled from one column- to one for each street address, city, state, and zip. In some cases we need a comma added between each street
...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 staff member that completed that shift. We are at the point now where we need the spreadsheet to aggregate
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
...(excel) made, each containing two functions as follow: Spreadsheet. 1 -Function. 1: Import the price data from Kraken([url removed, login to view]), XRP/USD, XRP/EUR, XBT/EUR, ETH/EUR -Function. 2: Import the price data from Korbit([url removed, login to view]), XRP/KRW, BTC/KRW, ETH/KRW *All the data needs to be updated as often as possible(Ideally less
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.
I have a csv file of about 50,000 lines in French and English. But the two languages are mixed and I wish that a whole column is in French. The work is in two parts: 1: Find the cells that are written in English 2: Translate them. I think a script is needed for the job to be done quickly. But I do not need the script, only the result.
I WANT MACRO CODE THAT CALCULATE IN EXCEL AND PASTE DATA IN WORD IN A SPECIFEID AREA ONLY EXPERTS BID PLZ ONLY ONE HOUR WORK FOR EXPERT. THIS IS JUST A SAMPLE WHIHC I WILL PAY BUT MORE WORK WILL BE GIVEN DEPENDS ON QUALITY FIX BUDGET 5AUD /HR
need script to copy cells and process them. Instructions: [url removed, login to view] buton to start process (c3) in MVP GIS DATA QC [url removed, login to view] D1 to END to a new spreadsheet(MVP DATA CHECKER) [url removed, login to view] on below CASES color rows red or green CASES --1 IF Pending Replacement= yes and Validation Complete yes then color entire ...