We have a large, existing ERP-system developed in Delphi XE7 for Windows with an underlying Firebird database. We would like to convert this application to a Delphi Firemonkey application, so it will run under Windows AND OS X. The application contains almost no logic, only user interface. All the logic is in the database. The application contains approximately: - 45 forms - 90 dialogs...
I have a reasonably simple excel workbook that I need some help with....template and the other 2 worksheets containing data. I need some help with VLOOKUP's or a Macro that will fill in some of the cells on the front worksheet using data from the other worksheets. I've tried with my basic VLOOKUP knowledge and think it probably needs a macro instead.
I need a VBA expert who can help me highlight certain cells based on values in given cells. I would prefer a strong English speaker as the content is quite difficult and I have a very tight timeline! I will share the file with candidates and fully explain what I am looking for. Thank you!
My powerpresentation is best, I have command on the graphic design in presenting
...excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: We have two worksheets in a given workbook file. We need to have various "column transpose" and lookups from sheet2 to sheet1. This is an ongoing progject meaning, if we need to add functionality to this macro or create
So i need someone to fix this code or change it idea is that i get pop up input box where i type unique router ID which is different for every time i will run the script, and on next line it will generate code like: example: copy usbflash1:1234 usbflash0: copy usbflash1:abcd usbflash0: this code will stay same copy usbflash1:(only this should be changing) usbflash0: ----------------------------...
I'm actually a trained graphic designer, but am not doing that now and hence do not own the software. I want to re-create a very simple text based logo in adobe illustrator, and I will also need a pdf version as well. I would prefer to talk with you about the rest of the details as we go Regards, James
First of all, please note that the conversion is from Swift to Objective C (many do the other way around). I just happen to be savvy programming in C at large and not proficient enough in Swift (and I don't want to use various bridging functions or combine Swift and Objective C for this particular problem I am solving). Project task: At [log ind for at se URL] a gentleman has provided a lib...
...can see that there are 7 quantities (2+2+2+1) required on 5973, 5974, 5986, 6393. So, if there're 7 QTYRQRD while 5 FONHAND, we're short by 2. I want you to write a custom Macro or a custom excel function which does that for me. What I want Excel to do is, sort the QTYREQRD by DATE, and allocate them by First Come First Serve. For example that we
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
...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
There is a requirement to produce a 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 Summary...
...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
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 on sales.
...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 of the
Hello there I am interested in changing my shopify store to set it up for conversion and bring in a high volume of sales but I desperately need help since I have no idea what i'm doing. My method is dropshipping using aliexpress and this is the URL www.techsbubble.com.. Please note i'm not just interested in a small number of sales or to break even the whole goal here is to see a profit ...
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on ..."TTL" set keeps failing to import all CSV data records before running remaining excel macros) currently running: Files/HB/POS Sync Files/[log ind for at se URL] Files/HB/POS Sync Files/[log ind for at se URL] Files/TTL/SCRIPTS/TTL-INV [log ind for at se URL]
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
Quantopian Algorithms are written in Quontopian language but I need my Quantopian algorithms converted from quantopian script to Python. You will have to import all the dependencies and call the API from Interactive brokers (IB) platform. Attached is the IB API instructions for the project. [log ind for at se URL]
...tables. The data from the html needs to be transferred in an xls table structure (html docs and xls structure given be me) Regqurements: - program in php 5.6 or better 7 compatible - PAP - form to select html file (in) and xls output file (out) - program to convert tables to xls - some processing messages to confirm conversion
I have a report in Excel with 4 different Graphs p/sheet and those graphs are taking the information from the same file with all the data by day included in the same sheet. I need to have a button that says "Weekly" and move all the information of the graphs from Daily to Weekly, of curse summarizing and combining the daily data into weekly data. another button with "Monthly" a...
I have custom module for export .XLS file with some order datas. I need to generate one more .XLS file from same module with different datas on it: order number, customer name, address, zip code, city, email, phone, total amount, payment method. If you are willing to help me, feel free to make an offer. Happy bidding! MAGENTO PLATFORM 1.7
Hello, I need to merge two xls file, one with measurements done at defined times, another containing a continuous datetime with other mesurments. A more detailed spec list is provided in attachement (with samples)/ please contact me for further informations. the solution must use as few processing time as possible.
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
To draft up facebook advertisement text and headline for vitamins and health supplements monthly facebook advertisement campaign in order to achieve high conversion, high relevance score, high click rate. Freelancer to quote service fee for each advertisement. No graphic design service needed.
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
click each link and indicate in column 'i' with an 'x' if link is leads to photo. If error occurs and link cannot be followed then leave column 'i' blank. Link is in column 'h' EXAMPLE in file: row numbers 228,645 & 228,644
create a simple excel macro that looks up a stock ticker online and place a current price value in an adjacent cell. to have a refresh button on the excel sheet that allows for multiple refresh of multiple cells with one click.
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
I need someone to design high converting html email templates for a loan company. The Loan company is based in South Africa. The target market is for anyone who requires a loan. This will be on a continuous basis. So to start we want to test the email designs to ensure they convert and work. We will require one to ensure they are designed properly
Dear Freelancers, i need help at modifying payment plugins for my woocommerce website. im from Indonesia, so The payment plugins is indonesian based credit card payment processing, so they must only accepting payment in Indonesian currency "RUPIAH". while my store selling products in USD, so it needs to convert to Rupiah before customers pay. This conversion will be inform on customer...