Hi I'm trying to ...week 1 uses 100 hours, then the hours should still be 100 for the next 12 weeks. However if you put in a 0 or any other # into used hours for weeks 2-13, the average available will get updated to show an updated # for each week. I tried some formulas attached but nothing was coming out correctly to even start me off. Thanks
I need a macro to automatically copy formulas based on the first row and paste it to rest of cells. Please find the two files. I have 40 files like this. The whole files need to go from step 1 to last step in matter of seconds.
Please look into the sample files. In every step it is just the data of the previous sheet and the same has been copied to rest of cells every time. I need a macro to go from step 1 to last step within seconds. I have 40 files like these.
...with these specifications: 1. Two EMA Crossover Buy & Sell signal - I should be able to choose periods in parameters 2. with Trailing SL & Tgt - I should be able to keep it ON or OFF in parameters and if i choose ON mode then i should be able to choose my TSL % as well as SL% 3. Popup and Audio alert on signal generation - I should be able to switch it
I run a macro to send an email on a daily routine set in Windows Task Manager. I use Macro Recorder to build my macros ([url removed, login to view]). The macro imports into the clipboard the list of receipients from a .txt file. This allows me to update the list without having to play around with the macro coding. The script that does the
Objective: We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run the
...need an advanced excel user to help me with formulas where I want a search criteria (2-level drop down selection) to find the corresponding data in a big table and populate its content next to the search field. Note: NO Pivot Table. Formula needed! Budget: $15 Task must be completed in one to two hours. Hopefully a quick formula for a Power User
Part 2 is about scraping the program performance test database iniside the program, quite easily from the windows applications (not sure if it exists in linux or any other) Part 2 - Pic 1: Download the pogram performance test 9.0 Part 2 - Pic 2: Click on the database icon Part 3 - Pic 3: Right, upper corner is red highlighted with search now
Need an excel macro to get prices from website into excel
Financial/Business analyst ,Excel Macro expert needed for some task .
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
Requirements: -PDF format 2 pages -Place my companies logo at the top left corner -Have formulas for major chemistry subject areas grouped together in a clear and nice manor -White background and must look professional I will provide you a list of formulas and I want someone who can rearrange the formulas in a better way but with a similiar layout. Must be experienced in creating profession...
I have a sharepoint list that I wish to show a group total of "weight" per "Flt Number". For each flight in the sharepoint list I need to sum the weight of each passenger and present it on a view with the total for the flight. Example: (Passenger 1, 80, Flight 1) , (Passenger 2, 103, Flight 1), (Passenger 3, 45, Flight 1), (Passenger 4, 96, Flight 2), (Passenger 5, 68, Flight ...
I need someone to create a Chemistry formula sheet for my educational company in PDF format. The formula sheet must include: [url removed, login to view] concept formulas [url removed, login to view] Laws [url removed, login to view] Structure [url removed, login to view] Kinetics and Equilibrium 5.Acid-Base [url removed, login to view] [url removed, login to view] [url rem...