...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
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: ----------------------------...
I need an android app written to capture 1FPS audio and video. REQUIRED FUNCTIONS 1. App runs automatically at startup. 2. App forces device to enter and stay in a state of maximum power saving. 2. Audio and video will be saved to the SD card. Video recordings will be one hour in duration. The oldest data files on the SD card will be erased to make room for newer ones when SD card is full....
Small piece of web test script that browses through web sites, such as a shop catalalog and calculate...extend and attach to other processes - Can be run within Web Browser (Chrome/FF) if needed, so that tester can see what is happening - Perhaps use tool/plugin like Katalon Recorder, that is free and easy to install and use for no technical "testers"
...started writing some short notes of what I think should be included in the book, but I became lazy and shelved it, but I still have the little drafts. I have now bought a recorder to record my stories and what I need included etc. I know most stories to be included in the book, so I am looking for a good very creative writer to flesh it all out and
...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 need help with the ...friend. One pushbutton for REC and STOP. First push, REC: LED1 ([log ind for at se URL]) blinking continually every 7 seconds for 200ms LED2 blinks ONE time for 120ms (sends message to recorder to start recording) Second push, OFF: LED1 ([log ind for at se URL]) and LED2 off. LED3 (or something similar) making a circuit to ground (see image for sketch)
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
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 onto the consolidated Daily Sales Summary...
...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 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 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/[log ind for at se URL] Files/HB/POS Sync Files/[log ind for at se URL] Files/TTL/SCRIPTS/TTL-INV [log ind for at se 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 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.
I am looking for someone to code and (very briefly) advise on the design of a basic arduino device that can do the following: (1) Upon #1 button press, start to record input* from #2 button; (2) Upon #1 button release( or depressing button a second time), stop and store the recorded input* of #2 button; (3) Upon #3 button press, play back stored input from #2 button. (4) Subsequent #3 button pres...
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
create a simple excel macro that looks up a stock ticker online and place a current price value in an adjacent cell. to have a refresh button on the excel sheet that allows for multiple refresh of multiple cells with one click.
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)
...Familiarity with Puppeteer & [log ind for at se URL] would be good. Task are as follows: 1. Fetching list of urls from Firebase &/or db like MySQL/Mongodb by reading a [log ind for at se URL] file. 2. Integrating & modifying [log ind for at se URL] to select a window from the list of open windows for recording programmatically
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([log ind for at se 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...
I need you to develop some software for me. I would like this software to be developed for Windows using .NET.