First: There is a folder with many pictures of recipes. I need to be sur...Expenses are assigned to the right report on Expensify. Second: There are around 200 bank transactions in an excel file. For each one, You need to identify the reference of the corresponding expenses reports from Expensify. Then write it down in the excel file. That is all :D
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
...the UK. We also record in an excel file of what we have purchased (from different ecommerce websites in the UK). And we also have an email address where we get all the invoices from these websites where we purchase from. Problem: I doubt that there's a leak! The person in my team who is making these purchases, might be using the card for buying goods
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
looking for a part time assistant bookkeeper. No experience necessary. Must be 18 or over and...the hours of 9am-5pm. Job duties include but are not limited to: Picking up mail and dropping off mail at the post office Sorting through the mail Filing/scanning Bank reconciliation Process AR transactions Process AP transactions Medical Claims processing
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
I just need a couple/few hours of design help: I have a set up a simple online store for selling domain names, using Wordpress and Wordperfect. I'm experienced in other platforms (sql/vb/vba, etc) but novice with web design. The site is basically two pages: The "Front page" with links and product list, and the woocommerce cart/checkout page(s)
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated -...Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
...steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials to further assist
...can upload/downlaod information from an MS Access database to WooCommerce and back using the WooCommerce API. [login to view URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would
Need VBA code to select a row in external SysListView32 and send right click to it using sendmessage or postmessage API. Assume hwnd of SysListView32 is known.
I need a dash board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I need the data to extract details from master file to sub files on click.
Hi my name is Sotiris Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word that i have uploaded which includes a description of what i need the excel file to do. For any questions do not hesitate to ask.
Hello, I have an Access database with an existing form. I need someone to develop a script that exports the form as individual pdf files for each record in the database. The name of the pdf file will be derived from a field in one of the tables. I will upload an example Access database shortly. Thank you, Simon
Assist with Inventory Reconciliation in Enterprise IQ (IQMS). Accounting skills and must know IQMS manufacturing ERP software (Enterprise IQ).
I want to prepare a excel workbook in which, I want to enter data about the materials and labour required. Accordingly, in a second sheet an analysis will be prepared. The labour rate will be intered in first sheet as an input. Each and every time a new PDF need to be generated with given file name format and need to be saved. Similarly the loop need
I have two workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inpu...workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inputted) to populate to another based on a couple of variables. Best done in VBA. I will provide the working files to the successful candidate.
...over 25 years and use a custom built excel spreadsheet to calculate initial and ongoing product costs and to assist with the setting of sell prices. Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate. We seek a VBA expert to re-write our software to correct
Hi there, I have three columns in excel with core data and three columns with input fields, when user puts value in the input fields it need to check if it is according to the core data (value is on same row) If not is the same, it needs to show message box stating, value is not the same. then user can proceed to change value or keep different value
...talented professionals for its Ahmedabad office. Principal Accountabilities: 1. Reconcile bank and credit card accounts for multiple clients 2. Conduct weekly/monthly reconciliation of all bank accounts 3. Accounts payables/receivables management 4. Report & produce financial statements on a regular basis 5. Liaison with external accountant & CPA
All details are attached file. Bid only if you can complete the task today. You need to use only formula not VBA. Fixed price: £20
I just need a simple Google Sheets script to copy the entire last row and paste it down one row below. This script will be run once a day to keep co...the entire last row and paste it down one row below. This script will be run once a day to keep copying down the last row for each new date. I can get this scrip to work in Excel but not Google Sheets:
Create a VBA sub program that creates a game for multiple players and finally declares the winner. The detailed procedures to create the game are given below: • Create a spreadsheet and place the buttons as shown below in the picture. • When the button “play” is clicked, the program should ask for the number of players and the number of cards. • After
I have an excel workbook that contains a number of spreadsheets. The spreadsheets contain various data - one sheet is a person's roster, another is an extract of their timesheet entries, another is employee data rules. I'm looking for a way to automate the reconciliation process for each employee (over 100) to check if the timesheet entries match the