Design an excel VBA macro that copies the "Fees and Other Costs" table within a superannuation fund's product disclosure statement (PDS). The product disclosure statement (PDS) is a PDF document that contains information relating to a superannuation provider, see attached examples. We require the Excel VBA Macro to find the table within the
...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 generation from raw data. We have
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 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. 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
...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 staff member
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
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....