See attached document. Open this in Excel. In the developer tab you can run the macro and see the code. This macros is is meant to convert a flat sheet of data( Creditors ) into an importable batch of invoices. The macros is supposed to stop when the last line of data is reached on the creditors sheet but it does NOT STOP. it loops indefinitely.
I have a list of cost in a sheet, based on date. I have a business plan in other sheet with some categories of cost and incoming. In first sheet i would like to associate to every cost or incoming a specific voice since this cost goes automacatically in second sheet to the cell of that categories of cost for that month
There is a consolidated excel file that consists of questions and answers. I need a macro that can copy these answers to a predefined template. There are different kinds of the answers and corresponding rules. Needs to be done today.
On excel 2016- I have a macro set up already to compare two files and highlights differences in different ways depending on differences .i would like to have it reviewed and corrected as it is still not 100% behaving as expected.. What is expected is as follows : 1-colour tab in red if it’s worksheet is modified 2-highlight in yellow if an existing
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 VLOOKUP
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!
Take several answers that have several responses that are a list into pivotable items. so that I can cross reference them with other sets of data. Need done quickly
...rs("column1"), rs("Column2") 7. If filenamers("column2") not exists, then copy file from temp-location to location specified in variable for the current row in the db table. Search the current file, based on db info, and replace the tmp-text rs("column2") with the replacement text rs("column3"). Return T or F if operation was successf...
...optimisation on an ongoing basis. 3 months initial contract. Results based ongoing future contract for 12 months after initial contract. - Website (Wordpress) - Google (Search & Adwords) - Bing (Search) - Permission for us to use keywords in other locations (i.e. yellowpages, other local search). Please specify cost per month for initial 3 months, subse...
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: ----------------------------...
...path should be round trip and the only results we need are the prices for the absolute cheapest flight provided by each website. Example: Flight 1: LAX - PHL on Sept. 25th return PHL-LAX on Oct. 2nd. JetRadar Price: $234 Expedia Price: $335 Google Price: $238 Priceline Price: $285 I would like the results organized and group-able so that we can
...(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
There are two parts of this project. 1. Simulated the given paper and obtained all the given results according to paper. 2. Compare some results.
need a macro that selects only cells with number format (including cells that display as text but actually have a number format e.g. cells with "n.p" ) and copies all number format cells from the input tab to the output tab. Have tried using the goto special function but it won't select the "n.p" cells or cell with a minus figure. plus goto special
...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
Hi I need first page ranking 2 website free trial to see results for USA region first. If successful then then I can hire you monthly with more websites. But I need trial to see result thanks. Please don’t message me if you cannot provide trial to see results.
There is a requirement to produce a consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook
...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 need help developing a node.js server script which receives a post request of continuous read and a few arguments, runs a python script which will constantly stream data as its callback is called. This data will need to be saved to the mongodb as it is received.
Current Search Results - See example attached. New Format - See example attached. Required Format: All images same size to left of Title & Description. No URL is needed. Please let me know if you have any questions. 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
Our business is called Connect the Dots Digital. We help CEOs and subject matter experts improve their sales ability through LinkedIn. We are creating a lead magnet tool that will allows people to download their current LinkedIn connections and then run them against a simple analysis tool. While we want it to be helpful and to look professional (e.g. a few charts), this is a very simple analysi...
...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
...software). 2) The tool must take each keyword and run a query in Google with "allintitle:keyword". 3) Google will return a number of results from the above query. For example, Google returns the following text: "About 92 results" 4) The tool must store each keyword with the number of results (from allintitle query) in a new CSV fil...
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.
So I would like to have a radar screen that I can enter multiple pairs and then on the screen see 1). The current value of the RSI. If between 30 and 70 I want that number and be colored black. If it is below 30 or above 70 I the number to turn green. Then 2). On the bollinger band if price is between the 2nd STD deviation of 20 it should say Within bands. If above the top band it should say...
Hi There. I have a site with 20 pages of text content. You need analyze it and create list of keywords for google. The frequency of keywords must be more than 1000. Also need write 20 first links of results for each keyword. In your request please take the answers for the next questions: 1) What programs are you using in your work? 2) How many keywords
To replicate the computational model as described in the papers attached preferably using Fluent. This will be an year long association so quote wisely (Quote now the initial project price only, later will be paying as per the minor tweaks required in the project).
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
Require the services of a good SEO professional. I am looking for someone who can drive organic traffic quickl...quickly using white and blue hat techniques. Person must have done a Escort SEO job like this before. My main focus comprises in making the website appear on the first page on Google for certain keywords and increasing my overall page rank.
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.