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
...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
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
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.
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
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.
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)
We use the following macro for gathering information from invoices on spreadsheets and compiling them into a larger database type spreadsheet. The Macro has been working fine for years but has stopped working in our last update (running office 365). Macro gets stuck on this Err5 With Application ChDrive (Left([login to view URL], 1)) Hopefully
Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date). The spreadsheet would generat...
I want you to develop a macro that will run everytime a pdf document is opened. The macro checks whether a number exists in a pdf page. If yes, this page is deleted. Please check the attached. I want the number 1083004703 to be checked in all pages. It can be found in page 4. Page 4 should be deleted and footer should be changed (from ... of 22 --->
I have a pdf document. I want a macro to run when the document is opened. I want the macro to check the pages of the document. If a number is found in the page, the page should be deleted. Please check the attached file. For example, in page 4, the number is 1083004703. When the macro finds this, the page should be deleted and the footer should be
...Freelancer, We are looking for cooperation with creation of one Macro with two components project can be solved with two Macros depend on proposed solution. Functionality: - copy predefined excel filed in to desired location (2x) - location need to be identified automatically by macro/s itself based on following parameters * Find last entry in
Hi. Just to give a brief des...150 email ids which is listed in excel spreadsheet in a folder whom I contact on a daily basis. I don't want to send any email apart from this list. So I want to create a macro in outlook 2013 where if I try to send any email apart from the list then the outlook will give me a popup. Will u be able to develop the macro ?
...detailing each managers direct reports on a seperate row (see summary sheet for example). The example below has 3 rows of data, but the actual file may have >30,000 rows, so the Macro must be able to handle many rows. Once the summary sheet is created, it should vlookup data from the Details tab to the Summary Sheet for 3 columns. The final summary sheet
...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 the 3 ways I'm trying to filter the data and buttons to use macros after dates are inputted. I also attached "Book 2". It also has 3 sheets...
Expert of proc IML and understanding of mixed models in survival analysis with different variance covaraince structure. Need help to identify the errors...understanding of mixed models in survival analysis with different variance covaraince structure. Need help to identify the errors and help finding a solution for the errors make the macro work fine.
...script Excel Macros to add a new feature that will post real time Forex instrument historical data to a designated Excel worksheet. The current REST API application and Excel Macros presently posts real time account and exchange rate data to designated Excel worksheets, as well as automates order placement and trade execution through Excel. This project
I am a survey...consumes most of my time. I do have the report format in word but I need to build an excel report with formulas, macros and vba's to finish my work in very short time. I do have the idea, but need an excel macro vba expert to convert my idea to reality. I attached a sample report format. Any excel vba macro experts, please let me know.
We are a field surveying company that has a survey being used in the field, there is a weekly csv file created...surveying company that has a survey being used in the field, there is a weekly csv file created that is in the same format with extra columns that may be added. I am needing a macro to be created to reformat the data into a different report
We are looking to develop a set of macros that help us track emails in Outlook. The project will require the below skills: Excel VBA, Excel Macros, Visual Basic, Microsoft Outlook, Excel
Hello freelancers, I need an excel macro to match two excel files of drugs according to drug names that may be different, or according to the barcode if it exists. Objective to have a unified excel file with the fields of both files. Regards,
I am looking for someone to write a Macro. The macro will do the following: Take 2 excel files as input, able to select 2 columns, it will compare those 2 columns and output a new workbook/worksheet where it provides all the rows where the column values matched and another workbook/worksheet where the column vales did not match.
Write a macro to enter a value into website and copy the output. See video attached and template.