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!
Simple app, opening screen, follow up, depending on what is entered on the opening screen with a selection being placed in the Gallary from a pre-set set of images, or alternatively, a created set (pictures you take yourself).
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
We have a spreadsheet that needs to be formatted. All of the data is in one cell - we need it broken out into multiple columns (Company Name, Website, Address etc.. ) We need this completed ASAP so please only bid if you have time today to complete.
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: ----------------------------...
Following points in this macro are running well except points no. 5. & 9. Very small project. 1. Search tool to be placed in a folder along with multiple data excel workbooks. - DONE. 2. Tool should look for a keyword in all the existing workbooks in the folder only and copy paste the entire row in the search tool. - DONE 3. It should paste the workbook
...(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
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
...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 onto the
...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 a cell phone accessory store that sells brands like Lifeproof, Otterbox, Case Mate, Speck, Spigen, etc... Basically I'm wanting someone to design a banner/poster that will stretch about 12 feet long and about 2 feet in height. PLEASE NOTE WE DO NOT HAVE ANY DESIGNS OR IMAGES TO PROVIDE. WE NEED SOMEONE TO BE ABLE TO BE CREATIVE AND MAKE IMAGES
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
Have changed my business name, but would like a website similar to my old one. The website is [đăng nhập để xem URL] Would like to use the same layout but photos and information changed. I would like to keep the contact information script at bottom. That does not need to be changed. I will provide photos and where all information needs to be placed. As well as new logo for business. This will ...