Data net web application excel macro jobs
I have a reasonably simple excel workbook that I need some help with. It has 3 worksheets with the front worksheet being a "form" 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 VL...
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!
We have a few medium to complex 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
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: ----------------------------...
Need help with a workbook to tell the program what to search for and then have it organized a certain way.
...(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 have here, Job Number 5986 required
...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
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details .my budget is low thank you
...i'm 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
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details . thank you
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
...some data has been exported to a .SIM file from an Energy Modeling program. I need to have the .SIM file parsed and *some* of that data exported in a format that 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
download the data from sap and automate the report and share to all recipient.
Write excel macro to read data from sheet and process is using predefined logic. I will provide predefined logic to selected candidate. Fixed price: £100
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.
need a quick fix to a dedupe macro very simple issue for a macro expert !!
Im looking for an excel spreadsheet with a macro that when clicked will take the data from tab 2 (source) and save the data to the matching unique symbols on the tab 1 (destination). Thank you!
I would like a Macro created in excel to make an XML file from the Excel file supplied. Please see examples.
Hello. I have a big list of hashtags in the sets of 5 and I want a macro to create different versions of hashtags. I will send you all files and explain how macro should work.
...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
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 need someone to design a macro that will copy and paste a range of cells to other sheets based on the values of certain cells. You will see the list of requirements on the "Main" sheet
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 attach source and final result with new data to write dinamically (see last field of final result)
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).
Volkswagen has a site, https://www.volkswagen-car-net.com. Here I can log in and turn on my car heating/air-conditioning. I would like to automate this task so I execute it from Eventghost webserver.
I want you to develop a macro that will run every time a PDF document is [login to view URL] rest of the message will be [login to view URL] expert bid me . thank you deadline 24 hours
I want you to develop a macro that will run every time a PDF document is [login to view URL] rest of the message will be [login to view URL] expert bid me . thank you deadline 24 hours
i have some wok and some PDF .I want you to develop a macro that will run every time a PDF document is [login to view URL] rest of the message will be [login to view URL] expert bid me . thank you
I need you to develop some software for me. I would like this software to be developed for Windows using .NET.
I need you to develop some software for me. I would like this software to be developed for Windows.
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
I need a formula through which I put up in the code to find result..
...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 ?
I need for my team someone to build desktop apps. the app the we need now include opening multi web browsers with proxies and work on each one with macro. receiving commands and data from api.
I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example).
...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 the 3 ways I'm trying to fi...
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.
Convert Excel with Macro into an app I would like to get a multi users order booking and inventory management excel file converted into an app
I have some work, in an Excel spreadsheet. I have a spreadsheet in which I need specific cells locked after specific dates
Hello, I need an outwit scraper. I need it to first extract all instagram posts from a handle then fast scrape for contacts.
