...CSV files into 1 structured report split over 2 cost centres (1 XML and CSV for each cost centre) XML Data will change daily (will have the same file name and location) VBA code written to pull in the XML file, refresh all data and export the report saved as .xls STEP 2: Use the saved daily reports to automate the production of both a weekly
...foo/team-san-diego-padres http://www/[login to view URL] From the above, I know that for the first one, I might need to redirect to the 'team' controller, then do a database lookup for the name 'san-diego-padres'. For the second one, it might be the players controller, the index action, with an id of 'steelers'. The URLs contain information that is both
Hi there, I'm looking for someone to build a tool that uses VBA or excel functions to call bing API and retrieve the first result then log in the domain name Basically, I have a list of companies and I need to get the domain name of each. e.g. I have a company name "Midmac" and I need someone to call out Bing API on the search term "Midmac", retrieve
Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i ...
This initial project involves creating a formula that will analyze data in a worksheet tab and sum values by month. After that, doing a lookup on another tab and if a match is found more the sums to the appropriate cell. I have the logic all mapped out AND I would like a button created as I will need these calculations to be done on a monthly basis. Regards
...don't need to worry about that. What I need someone to do is to 1. With the outline for that chapter in front of you, find the requisite material in the "full" chapters and cut and paste what is missing. There are a couple of "full" chapters. I'm not exactly sure (since I was working out of 2 accounts with a couple of different versions) if the fulls
Im working on a project that has a lot of excel calcualtions , sheets and formulas. I need to automate the process to make it a little more user friendly. I have some basic knowledge of VBA but am havign trouble figuring out the best way to streamline my project.
This initial project involves creating a formula that will analyze data in a worksheet tab and sum values by month AND then do a lookup on another tab and if a match is found more the sums to the appropriate cell. I have the logic all mapped out AND I would like a button created as I will need these calculations to be done on a monthly basis.
Good day, I want to hire someone who will be able to create me a point of sale system through excel vba. It must be able to meet the following requirements. 1.) Add inventory and price 2.) Keep track of customer listing and sales 3.) Create payment receipt 4.) Inventory count where an email can be sent if it is at the minimum 5.) Sales report for
...to see if there is anyone who will be able to assist me with creating a VBA excel add in that I am able to push data from an excel to a google spreadsheet and vice versa pull data from an google spreadsheet back to excel. I want to have my colleagues be able to update through excel and if I am on the go make changes through google sheets and sync. I know
...give u a DID supplier or u can propose a better one. The number is a fix Chilean number, needs to forward to a cell phone Chilean number. We need to use a recorded welcome message in spanish, and press 1 to a cellphone and 2 to another cell phone. Actually the provider i am testing is didx.net. I buy the number, etc. Information of forwarding https://www
I have a VBA userform that reads data from a sheet of over 200,000 entries with over 200 columns per entry. I need to convert this into a website that can be sorted, filtered and searched like in Excel. Also need the ability to import CSV files to add to or merge with the existing data if it already exists. Ability to export refined search data as
...feeds a balancing ledger, by fund, with columnar sub-amounts for Non-restricted, Temporarily restricted and Permanently restricted totaling fund balance. Schedule needs to lookup and/or compute ratable Contributions, Income, Expenses, Releases and other adjustments to balances, by fund. I will not be able to educate a person on fund accounting or
I have Excel hotel meetings game created in .xls format (around 2006) and it now doesn't run, throwing up a runtime error everytime I open it in Excel 2016 on a Mac and PC. I need a VBA expert to review the macro's and VBA code and fix the game so it runs on both Mac and PC on in the latest versions of Excel.