...Microsoft product, as I am done with the constant errors and crashes. Unfortunately most of my data is supplied through Excel, so there is not much I can do about that, however I will not risk storing it on Microsoft's garbage. I am open to suggestions on other databases. Looking for someone that is not only great at setting these up, but can offer solutions
need a macro that selects only cells with number format (including cells that display as text but actually have a number format e.g. cells with "n.p" ) and copies all number format cells from the input tab to the output tab. Have tried using the goto special function but it won't select the "n.p" cells or cell with a minus figure. plus goto special
I have a project to design an A4 bookl...work to show off. Design inspiration needs to look like the attached. Not exact but something like that. Minimal, clean and modern look and feel. The document is like a workbook where you fill in each section. More detail once you get the job. I don't have a hard deadline so I'm looking for good work here.
...see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation
...consistency of design and layout you must: • Ensure Columns are wide enough to display data properly and are evenly spaced. • Include a header containing the file name of the workbook. • Today’s date and a Branch name area must appear on the worksheet. (The branch name will be filled in when the template is used.) • Format the spreadsheet so it is clear
...consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook onto the consolidated Daily Sales
...i'm wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
...a project in 4 steps. I need this assessment completed before August 16th. because I will study this documents and answers on weekend. *The task is simple: You read the workbook and you answer what is asked about it. *The last one I've done took me 4 hours. *It can be more or less (depending on your English skills and knowledge about the content)
Combining several files with certain layout (the data will keep adding every month until 1 full year ) do data processing by macro , presenting summary using pivot and chart
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
I am looking for a quoting workbook for our sales teams to use. I want to be able to update the products, cost price, margin and retail price in the "backend" which will make it easy for our sales people to quote.
...can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a couple
Create Sample Dat...NUTS CODE etc. Ability to select # of data records Ability to select values for few fields which will be static throughout the sample data file. Deliverable is an excel macro workbook which takes some input parameters including the static field values, # of data records, type of template and then the output is a sample data file.
...such as Cell A8 in Sheet ‘Toll’ where there are two invoice numbers. In the ‘EFM’ sheet, the invoice numbers also include another set of numbers that are irrelevant to the workbook. For example, Cell A2, only relevant data is 27264, therefore V49779732 needs to be discarded. Also, A32 has this data “V50088895,27633, 27646, 27646,27633, S50075896”, t...
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before