Trying to run multiple reports off of a button push that filters data by date and then copies the data depending on criteria. So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for...
We have an Excel file with macros (XLSM). Download resource manager for excel from [kirjaudu nähdäksesi URL:n] Problem happens across multiple versions of Excel and OS. When downloaded from our website, or emailed, and the user tries to open the xlsm file, the first prompt is for: ENABLE EDITING After you click this, to enable
Microsoft Access module(s) needed to get Amazon orders XML from Amazon MWS. Module needs to get all orders from last 30 days and parse xml, append data to a table but only if not already there. (new only based on AmazonOrderID). Important: Your module needs to create the Signature MWS requires for each unique request. Module also needs to have function to get one order xml info but AmazonOrder...
...Organisation Chart . Admin can log-in to see employee list, he can edit a single employee details and can assign a Manager from a pre-populated drop-down a list of other employees, one will be that employee's manager. A org chart report (new page) can display a list of employee/positions in a hierarchy of who they report to. The chart must be interactive
i have some simple formulas on excel sheet & want when some certain condition meet it show pop up window.
Need to dynamically filter from drop down list in excel table. Need vba code w/ description/notes of code so new users can understand. Looking to dynamically filter the table ("Table") in file (also outlined by black bold line) based off the drop down menu highlighted at top of file. Bonus would be to add signature blocks and note page on how to send
I'm in need of assistance with a sales tool my company has created for our clients. It's an Excel spreadsheet our clients use to track their sales process. I'm having a hard with with programming the spreadsheet to automatically populate the summary charts on the first tab and some conditional formatting issues. Looking for help on a few spreadsheets
I'm looking for someone who can help to create a diverging stacked bar chart, as shown in the graph below (Fig1) of a survey. I have the data set in Excel ready and organized to be visually transformed into a graph. I'm interested in having the neutral responses at the vertical level (baseline), those who disagree at the left and those who agree at
From an existing Excel sheet read the path of a locally stored file from a cell. Copy the Thumbnail from that locally store location and append to a new cell. Then in a new cell create a link to the file that opens it when clicked on.
I need someone to write a routine to create a report based on defined rules using multiple excel files that will be received by e-mail. Report should be displayed as on the REPORT tab of attached file. This is made up of adding data from pivot tables from multiple data sources. All data to be received from 4 original files that will be received by e-mail
I would like to use customer filter and get the total quantity of the result. For instance i will select "BW" under "Invoiced By" and select certain product from "Product Name" drop down. Then I need the total quantity as a result. I need to have the option to add multiple filter from multiple column and get the quantity. Please check the attached file for sample d...
I hired an access developer on here who just disappeared and I need someone with solid VBA experience to resolve some issues with the database that were not completed. Once the database has been completed and can be used without any errors, we'll need to have all the data migrated from the old version of the database to the new database. I will provide
VBA for Corel Draw Project that will access data from records in a table of a MySQL or similar database on a server, and from the data perform a variety of tasks including: Set measurement units, page height and width Import and position graphics files (including .cdr) from server Scale and place images inside powerclips Find and replace approx 12
I have an access DB very sensitive information, I could be fined several if this data is being disclosed, I have several tables that need to be join on two simple Queries using join and unions and compare both to come with and output result in access everything has been done but need to be twicked the Queries just to display unique results that are not equals in one table, let me know thanks
I need someone to build a really simple excel macro to make requests to amazon's seller api. It's very important that all code used is vba and that it's a macro, not a plugin, since we are trying to build a consumer facing product and don't want them to have to deal with installing any plugins. Ideally, it should be able to run on windows or a mac