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!
Need savvy, native English writers to put together 2000 word articles for my blog. You will need to: 1. Write solid, engaging content (no fluff). 2. Use H2 and H3 subheadings 3. Space out content every few sentences & keep sentences short. 4. Write up a summary of each of the five 5 items. We will provide the exact format for the articles and the
Convert a plan and 3d view into a revit 3D model. Accuracy +-1" based on given parameters. Model to include slab, walls, doors and windows, roofs and columns. Family Types must be generic (single thickness) and dimensionally accurate, per typical construction.
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: ----------------------------...
Hello, I'm looking for a professional SEO content writer to write an approximate of 2000-word description for 5 selected online shops - Sephora Malaysia, Nike Malaysia, Adidas Malaysia, HP Malaysia and Exabytes. The descriptions need to be SEO friendly, contain a selected choice of keyword phrases we will send in the instruction file and, of course
Article titles: How to rank higher on instagram? Each article should be 2000 words long. There is far more work available if you produce good content for this job. Please start your proposal with words "evergreen IG" so I know that you read this.
...com/check-engine-light (remove space before .com) Must be done with care and passion. It is not a mere inauthentic article-spinning attempt. Points: 1) Done in MS Word. No more then 2000 words. 2) Layout is to be decently exact. At least 80% identical. Because I'll give your article to another person to replicate it's layout in Wordpress. So your article will
I need articles/blog posts written on a regular basis - approx 6-8 per week. Each article should be at least 2000 words and written in English. Writer must be able to write grammatically correct English and do light research on the topics. All of the topics will be similar and on printing, webdesign and digital marketing topics. I am not looking
...(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
See full requirements in the word document. I encourage questions and have provided links that contain a lot of the required information. The sub topics are listed in the word document.
...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
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.
Hi i'm looking for a music lover who will populate a spreadsheet of the most popular songs from the 90s and from 2000- 2010 in all genres. You must have the song title, the artist, the year, what genre and the most poplar line from the song on the sheet that I will provide. The list must be a minimum 1000 songs long. The longer the list the higher the
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.
Dear All, I have an urgent requirement to complete the survey in Kolkata. Survey can be taken directly with 500 people each in Kolkata. Survey can be conducted thru Mobile app and location will be tracked automatically. Should take this survey in multiple locations around Kolkata. Minimum 43 and maximum 62 questions in each survey. Budget would be 2500 rupees for 500 successful submission. Once ...
Need 2000+ words beautifully written and engaging blog covering below listed points. Also, please include royalty free images that will help the users understand the content better. - How to wear saree with pleats and without pleats - How To Pleat A Saree - How to pleat a saree pallu - Saree pleats tips - Saree pleating tricks - How to fold pleats
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
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...