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
Hello there, we are looking for an ionic developer for long term relationship. For like test you need to capture video and playback using ionic framework. Note: money will pay for this task.
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 b...
I need a new website. I already have a design, I just to install home page and email capture. there will be some text formatting of site. 2 page site. Home page with email capture and blog page.
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
Online interactive web [login to view URL] is able to intergrate with the [login to view URL] the user can upolad information which is in a PDF format. So the system will caputre the information and save it to a database system possible SQL but Cloud Storage is much more accurate and lower when it comes to [login to view URL] system must also pre-dispaly an web application user [login to view URL]...
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: ----------------------------...
...(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
I am a building contractor creating a marketing manual for other contractors. I would like to speak freely and have someone capture my conversation, tone and words to print. And then I would like them to add, elaborate and improve my subjects.
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