simple script in python 3, -read csv -delete row if contains x
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 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 want an 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
Aim: Create Excel Control worksheets that runs Macro to perform the following: 1 Extract two data file(.xls) from known location and remove unused column + N/A (300K rows) The file is very large and therefore need to be efficient and effective. 2. Export data to SQL (create 2 new table- [url removed, login to view], xx2 ) 3. Join/ map the two SQL table to a "product
Hello, Our company is launching a new time and attendance system that will 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
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
Hi dear web designers, I am in need of great website for my cleaning company in Los Angeles, Ca. I am looking for pink theme that you can find the color code in this website: [url removed, login to view] Service list is attached to project. Please let me know if I need to provide any text or extra information.
We currently have a all-natural formula that we need to build upon and make more effective. We can supply the current formula and would need it tested on bird droppings, mud, bug splats, etc. Needs to be a strong all-natural product that doesn’t streak.