I have a reasonably simple excel workbook that I need some help with....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 knowledge and think it probably needs a macro instead.
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!
I have approximately a 168 page manuscript that I want to have formatted for a 5.5x8.5 paperback book. It is all black and white, no photos, does have chapters and would need page numbering and table of contents. This project will not be ready for 3-4 weeks. Please let me know if can do conversion for ePub
...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 functionality to this macro or create
I have completed a draft of my dissertation and need someone to create a APA Table of Contents, a List of Tables, and a List of Figures.
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: ----------------------------...
We would like our blog posts section to have a different style than it has now. Our theme is understrap (bootstrap based), so the standard archives and post page is unstyled. We can customize the theme (using the child theme) or you can use visual composer, which we already have installed. Visual composer has some templates, but they don't match this look. I'm assuming you would need to ...
I need someone to write a simple sql query to copy fields between tables
...you access to cpanel • Create 2 database – one for staging and another for live. In each database, I need the following o Create 8 tables ♣ 7 tables get from API structure ♣ 1 table get from excel • Import data into tables • Create admin user interface according to provided html and login • Create table views for each table in admin (d...
We have a 44 page microsoft word document created by merging two documents and the formatting has gone haywire. Key issues are: 1. Random fonts/sizes 2. The numbering has been lost in some places e.g. it should follow 6.1 - 6.11 - 6.12 3. Not all headings are represented in Table of contents 4. Some areas are idented but have lost bullet points Looking
...can see that there are 7 quantities (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
I have downloaded a tables Wordpress plugin. Currently when I add content to it, the front end requires the page to be refreshed in order to see the updated content. What I need is for the tables to automatically refresh after X amount of seconds without page refresh. It is a simple addition. Important 1. The implementation must NOT cause server overload
We have shipping rate tables by weight for Germany, Italy, Portugal, Spain and Hungary - each table with 30 rows (weight -> price). We need you to login into our Merchant Center account and to add Shipping services for the countries (Portugal, United Arab Emirates, Austria, Canada, Italy, Malaysia, New Zealand, United Kingdom, Israel, Norway, Poland
...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
...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
Need a local in ukraine to research for companyes that produce and sell tables to detail companies. Im looking for companies like: [login to view URL] The companis listed has to be real and working companis. Who can do the job?
We have a proposal that needs to be prepared. Currently we have a main document in word, also have some documents in pdf text and drawings. We need to incorporate the pdf documents into the word document in the appropriate places. The entire document needs to be formatted to be presentable for corporate purposes.
Hi I prepare power points for management consulting firms. I normally design the slides but don't invest much time on the formatting SO i am looking for someone who is experienced to support me on the formatting and completing the design of my slides. please submit ur best bid
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 on sales.
...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 of the
I'm getting ready to publish a book. I purchased an official word template with a certain style for me to copy and paste my book into. It has two sample chapters to start with to copy and paste over, but then that's the end, and I can't figure out create the next 13 chapters to look exactly the same and still keep the page numbers flowing the way they
Edit word document provided with text from a provided PDF sheet to match formatting of PDF text. Document includes 8 pages of text that needs correction of grammar, spelling, spacing between words and punctuation, line continuity, numbering / sequencing, line spacing between sections of text, bold and underlining of titles.
i will send you a theme, 1 )I need to edit the tables , have the option to add more fields. 2) Disable the transform all uppercase 3) have video to be responsive on mobile. than just let me know what files you have changed and send me all the info to do on my website
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on ..."TTL" set keeps failing to import all CSV data records before running remaining excel macros) currently running: Files/HB/POS Sync Files/[login to view URL] Files/HB/POS Sync Files/[login to view URL] Files/TTL/SCRIPTS/TTL-INV [login to view URL]
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 am looking for someone to help me format a series of plays in the Samuel French style of formatting, at $5 per 10 pages of dialogue (even if the dialogue takes up a quarter of the page, I would still count that as a page). I have about 53 plays, and need help with getting this done within 2-3 months. I'm looking for someone who has playwrighting/script
...some structure of repeating tables. The data from the html needs to be transferred in an xls table structure (html docs and xls structure given be me) Regqurements: - program in php 5.6 or better 7 compatible - PAP - form to select html file (in) and xls output file (out) - program to convert tables to xls - some processing
MS Excel 3 year sales analysis by product category (pivot tables). Purpose is to find out which companies have purchased from 2016-2018 and the revenue change by each product category
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 button with "Monthly" a...
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.